Hi Karin

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

--
Regards
Roger Govier

"Karin" wrote in message
...
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!