Convert/rewrite SUMIFS formula to work in Excel 97

's Computer Specifications

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!

's Computer Specifications

Karin,

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

HTH,
Bernie
MS Excel MVP

"Karin" <(E-Mail Removed)> wrote in message
news:A94C7F21-93EF-4828-B39C-(E-Mail Removed)...
> 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!

's Computer Specifications

Hi Karin

=SUMPRODUCT((B2:B783=E2)*(C2:C783=F1)*A2:A783)

--
Regards
Roger Govier

"Karin" <(E-Mail Removed)> wrote in message
news:A94C7F21-93EF-4828-B39C-(E-Mail Removed)...
> 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!

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:A94C7F21-93EF-4828-B39C-(E-Mail Removed)...
> > 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!
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert SUMIFS formula from 2007 to 2003	Alex.W	Microsoft Excel Misc	24	3rd Sep 2009 03:01 AM
Sumifs formula in Excel 2007	Tigerxxx	Microsoft Excel Misc	3	9th Jan 2009 09:19 PM
Convert SUMIFS formula from 2007 to 2003	V.P.Smruj	Microsoft Excel Misc	5	6th Oct 2008 06:12 PM
sumifs formula in excel 2007	spudsnruf	Microsoft Excel Misc	5	8th Jan 2008 04:25 PM
Excel 2007 - SUMIFS formula use between tabs	=?Utf-8?B?VGVycnk=?=	Microsoft Excel Misc	2	9th Oct 2007 03:59 PM