I need to do a SUMIF AND

[Ed]

How can I do a SUMIF and a AND formula together.

I need to sum column F if the value H2 equals A10 in sheet eom_v1 AND IF the
value in column G, sheet eom_v1, equals "ACC"

SUMIF('[Test Data.xls]eom_v1'!$H$2:$H$958,A10,'[Test
Data.xls]eom_v1'!$F$2:$F$958)
SUMIF('[Test Data.xls]eom_v1'!$G$3:$G$958,"ACC",'[Test
Data.xls]eom_v1'!$F$2:$F$958)

T.I.A.

Ed

 

[Aladin Akyurek]

SUMPRODUCT(('[Test Data.xls]eom_v1'!$H$2:$H$958=A10)*('[Test
Data.xls]eom_v1'!$G$2:$G$958="ACC"),'[Test Data.xls]eom_v1'!$F$2:$F$958)

 

[Peo Sjoblom]

Something like this maybe

=SUMPRODUCT(('[Test Data.xls]eom_v1'!$H$2:$H$958=A10)*('[Test
Data.xls]eom_v1'!$G$2:$G$958="ACC"),'[Test Data.xls]eom_v1'!$F$2:$F$958)

 

[Ed]

Thanks Guys.

I've never used SUMPRODUCT before but have had this problem before.
Glad I asked.