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

"Bernie Deitrick" wrote:

Karin,

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

HTH,
Bernie
MS Excel MVP


"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!