Add criteria to SUMIFS formula

[RodneyC]

I need to add criteria to this formula:

=SUMIFS(GAM!$H2:$H894,GAM!$D2:$D894,$A8)

In addition to looking at $A8, I need it to sum the values from GAM $H2:H894 if and only if the value in GAM $A2:$A894 are equal to the value in cell $A$3 on the tab where the formula will go.

Thanks in advance

 

[jtakw]

Hi,

Just add another argument in the formula:

=SUMIFS(GAM!$H2:$H894,GAM!$D2:$D894,$A8,GAM!$A2:$A894,$A$3)

 

[RodneyC]

Hi,

Just add another argument in the formula:

=SUMIFS(GAM!$H2:$H894,GAM!$D2:$D894,$A8,GAM!$A2:$A894,$A$3)

Thank you kind sir

 

[jtakw]

You're welcome.