Expand on an exsisting Sumproduct formula

**fgruhlke** · 02-26-2014, 10:36 PM

Still finding the SUMPRODUCT function a bit challenging to fully grasp.

This formula works great to sum the miles (Q16:Q38) the team (A16:A38) drove in a particular month (B16:B38)

=SUMPRODUCT(--ISNUMBER(MATCH(A16:A38,INDIRECT(E3),0)),--(MONTH(B16:B38)=E7),Q16:Q38)

How would I expand it to check yet another column say (S16:S38) for the term " Charge Call" ?

So I can see the miles the team drove in March for all the charge calls.

Thanks a head of time guys!

Where can I go to study and learn more about SUMPRODUCT. Seems like just what I need to build interactive type dashboard reports.

**tigeravatar** · 02-26-2014, 10:39 PM

The extra condition is:
--(S16:S38=" Charge Call")

Each condition is separated by a comma, so just add a comma and put in that condition.

**fgruhlke** · 02-26-2014, 10:48 PM

This worked great .. thank you so much.. I Got to keep working at this!

=SUMPRODUCT(--ISNUMBER(MATCH(A16:A38,INDIRECT(E3),0)),--(MONTH(B16:B38)=E7),Q16:Q38,--(S16:S38=" Charge Call")