I need to do a SUMIF AND

  • Thread starter Thread starter Ed
  • Start date Start date
E

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
 
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)
 
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)
 
Thanks Guys.

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