Convert/rewrite SUMIFS formula to work in Excel 97

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

Bernie Deitrick

Karin,

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

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 -->> SUMIFS v SUMPRODUCT 4
sumifs, sumif with dates 6
Need Function/Formula that will add a column based on two conditon 3
I need alternative formula for SUMIFS in Excel 2003 3
Slicing Data (Alternative to SUMIFS) 2
Sumifs in Excel 2007 for only numerical values 15
Convert SUMIFS formula from 2007 to 2003 5
Sumifs formula in Excel 2007 3

Top