SUMPRODUCT Multiple criteria in one column?

  • Thread starter Thread starter steve in los gatos ca
  • Start date Start date
S

steve in los gatos ca

Question is can I use sum product to do the following?
I would like to sum the $amounts for Col A Fund 200 and
300 only?? So in essence I am requesting sumproduct to
find fund 200 and add $60 and $100 and also do the same
for fund 300. The grand total should be $320!!

Any help most appreciated!
steve


Col A Col B
Fund# $Amount
100 50
200 60
300 70
400 80
300 90
200 100
 
Steve

one way:

=SUMIF(A2:A7,200,B2:B7)+SUMIF(A2:A7,300,B2:B7)

or shorter and more general:

=SUMIF(A:A,200,B:B)+SUMIF(A:A,300,B:B)

Regards

Trevor
 
Back
Top