Thread: Total numbers in column where the row cell matches the search crit
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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


Reply With QuoteReply With Quote