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