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!