Convert/rewrite SUMIFS formula to work in Excel 97
 

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!

Convert/rewrite SUMIFS formula to work in Excel 97
 

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!

Convert/rewrite SUMIFS formula to work in Excel 97
 

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!

Convert/rewrite SUMIFS formula to work in Excel 97
 

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!