Convert/rewrite SUMIFS formula to work in Excel 97

[Karin]

Love the new SUMIFS function in Excel 2007 - works beautifully.
Unfortunately I've created spreadsheet in 2007 that has to work in Excel 97
and this function does not work in 97. How might I convert or rewrite the
following formula to work in 97?

=sumifs(a2:a783,B2:b783,E2,c2:c783,f1)

Summing a2:a783 if b2:b783 meets e2 criteria, and c2:c783 meets f1 criteria.

Thanks so much for any help!

 

[Bernie Deitrick]

Karin,

=SUMPRODUCT(a2:a783*(B2:b783=E2)*(c2:c783=F1))

HTH,
Bernie
MS Excel MVP

 

[Roger Govier]

Hi Karin

=SUMPRODUCT((B2:B783=E2)*(C2:C783=F1)*A2:A783)

 

[Karin]

Thank you so much! Perfect! Really appreciate the help!