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