Help with Formula and Pivot Table

[tbruce]

Hi All,

I'm trying to get a total count each time a specific value appears in column A. Counting is pretty straightforward with pivot tables and even formulas, but the curve ball I''m trying to work through is I need to also compare the value in cell A2 to the value is cell B2, and if the values match count as 1, but if the values are different count as 2. Here is a sampling of the data:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]A - Starting Invoice #[/TD]
[TD="align: center"]B - Ending Invoice #[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]120334[/TD]
[TD]120334[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]120353[/TD]
[TD]130343[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]120353[/TD]
[TD]121121[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]120334[/TD]
[TD]122323[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]120353[/TD]
[TD]120353[/TD]
[/TR]
</tbody>[/TABLE]

I'm trying to get the desired result to produce the following list either in a pivot table or with a formula:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Invoices[/TD]
[TD="align: center"]Total Count[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]120334[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]120353[/TD]
[TD="align: center"]5[/TD]
[/TR]
</tbody>[/TABLE]


Not sure if it would be best to use a pivot table here or a formula. Any help would be much appreciated.

 

[geo77]

Hello. Please reformulate your question. Your narrative doesn't match up with the tables. The bottom table essentially shows a simple conditional counting of certain values in the range [A2:B6]. Whatever you want is probably easy to do by using cell formulas.

 

[tbruce]

I don't know how else to reword this - the first section with table is exactly what I'm dealing with and what I'm trying for, and the second table example is what I'm hoping to generate as results either as a pivot table of other means. Any hep would be appreciated...

 

[geo77]

Good luck!