A better way to count

[JKLINGE]

I am trying to count how many times a certain value appears in a spreadsheet, but I am working with multiple values that all need to be counted. EX: "value 1"+"value 1" needs to have a count of 2, but then the value changes to "value 2" and may appear 5 times and needs to have a count of 5. The next value may only appear 3 times. Since "value 1", "value 2" and the next value change without a consistent interval, I am struggling to find an appropriate calculation.

 

[Scott Huish]

Hi, welcome to the board. If you have a lot of values, a pivot table would be perfect for this:

http://www.homeandlearn.co.uk/excel2007/excel2007s7p7.html

For a few values, COUNTIF formulas should work:

=COUNTIF(A:A,"value 1")

 

[JKLINGE]

I am trying to count how many times a certain value appears in a spreadsheet, but I am working with multiple values that all need to be counted. EX: "value 1"+"value 1" needs to have a count of 2, but then the value changes to "value 2" and may appear 5 times and needs to have a count of 5. The next value may only appear 3 times. Since "value 1", "value 2" and the next value change without a consistent interval, I am struggling to find an appropriate calculation.

Thanks, I have about 25,000 values, so I am not sure that a countif would work. I will take a look at pivot table options.