View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Sorting & Calculating

=SUMPRODUCT(--(A2:A100)="A"),B2:B100)

Or

=SUMIF(A2:A100,"A",B2:B100)

"Scotts" wrote:

If I have a column sorted by A B C and another respective col that has
numbers in it, how could I write a function that would add up all numbers
that have a respective A in the first col?

In other words I want to Sum (if any cell in col A = A, I want to add them up)

-----------------
Scott