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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF formula works in Excel 2003, does not work in Excel 2007
My apologies... it appears the issue is resolved. regardless, I'll do my best to explain it, so everyone can gain from the insight. The entire formula is actually 5 SUMIF formulas added together. 2003: Each one evaluates into the correct answer 2007: Each one evaluates to 0 (incorrect) (for convenience purposes, I am providing the first of the 5 in the cell) =SUMIF(H$6:AC$6,AP$2,H1018:AC1018) H6 through AC6 refer to cells that are supposed to represent dates. Ex: in L6, we have 04/20 formatted as General. AP2 is formatted as text, and contains '04/20 Both Excel 2003 and Excel 2007 consider this to be a match, but only in Excel 2003 does this work. However, we changed each of the cells in H6:AC6 to actual dates using DATEVALUE (the dates are all in 2009). L6 now reads DATEVALUE("04/20") and evaluates to a date (integer 39923, or 04/20/2009) . The SUMIF now works in both 2003 and 2007. "Niek Otten" wrote: Hi Harry, Please be more specific. What does "does not work" mean? What is your formula? What are the input values? What result did you expect and why? What did you get instead? How did you transfer the spreadsheet from Excel 2003 to 2007? -- Kind regards, Niek Otten Microsoft MVP - Excel "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 |
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) |