| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF formula works in Excel 2003, does not work in Excel 2007
Folks:
I have an example of a SUMIF formula that works in Excel 2003, but not in 2007. We did an IF test of one of the cells in the evaluation range with the criteria, and it came back TRUE (in other words, the IF formula confirmed a MATCH). Has anyone else seen this issue in Excel 2007? thanks, Harry |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF formula works in Excel 2003, does not work in Excel 2007
You'll need to provide more detail.
What's the formula look like? What's the data look like? Where is the data? What's the criteria being used? -- Biff Microsoft Excel MVP "Harry" wrote in message ... Folks: I have an example of a SUMIF formula that works in Excel 2003, but not in 2007. We did an IF test of one of the cells in the evaluation range with the criteria, and it came back TRUE (in other words, the IF formula confirmed a MATCH). Has anyone else seen this issue in Excel 2007? thanks, Harry |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF formula works in Excel 2003, does not work in Excel 2007
No.
Pl. share the formula and sample data. "Harry" wrote: Folks: I have an example of a SUMIF formula that works in Excel 2003, but not in 2007. We did an IF test of one of the cells in the evaluation range with the criteria, and it came back TRUE (in other words, the IF formula confirmed a MATCH). Has anyone else seen this issue in Excel 2007? thanks, Harry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function =IFERROR LOOKUP works in excel 2007 not in excel 2003 | Excel Worksheet Functions | |||
| Make Excel 2007 work like 2003 | New Users to Excel | |||
| Opening Excel 2003 file in Excel 2007: Links do not work | Excel Discussion (Misc queries) | |||
| xls file works fine in Excel 2000 and 2007 but crashes on opening in 2003 | Excel Discussion (Misc queries) | |||
| Embedded Excel 2003 spreadsheet in web page won't work with Excel 2007 | Excel Discussion (Misc queries) | |||
Hybrid Mode
