SUMPRODUCT Multiple criteria in one column?

[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

 

[Trevor Shuttleworth]

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

 

[Domenic]

Also...

=SUMPRODUCT((A2:A7={200,300})*B2:B7)