Total numbers in column where the row cell matches the search crit
 

Here is my scenario below. How do I get a total of the only values in column
B where row cell matches A in column A?

A B
1 A 100
2 A 200
3 B 300
4 C 400

Total numbers in column where the row cell matches the search crit
 

Try the below formula..

=SUMIF(A:A,"A",B:B)

If this post helps click Yes
---------------
Jacob Skaria


"Kane" wrote:

Here is my scenario below. How do I get a total of the only values in column
B where row cell matches A in column A?

A B
1 A 100
2 A 200
3 B 300
4 C 400