View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kane Kane is offline
external usenet poster
 
Posts: 14
Default 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