| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumifs will not work with a cell reference as criteria | Excel Discussion (Misc queries) | |||
| Convert SUMIFS formula from 2007 to 2003 | Excel Discussion (Misc queries) | |||
| I need alternative formula for SUMIFS in Excel 2003 | Excel Worksheet Functions | |||
| sumifs formula in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 - SUMIFS formula use between tabs | Excel Discussion (Misc queries) | |||
Linear Mode
