Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum Incorrect
There seems to be a major bug in Excel. I open a spreadsheet in Office 2000
Excel and a conditonal sum gives a correct answer. Open the same speadsheet in Excel 2007 and the formula gives another sum. In Excel 2007 if I copy that part of the sheet to a new sheet it returns the correct sum. The formula is of the form =sumif(a50:a67,"<x",e50:e67) sum in Excel 2000 = 315 sum in Excel 2007 = 290 Column a50:a67 is empty (has been deleted). If I highlight column e50:e67 in Excel 2007 the sum on the status bar is correct (315). Anyone had this problem? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sum incorrect | Excel Worksheet Functions | |||
Incorrect Am and Pm | Excel Discussion (Misc queries) | |||
Incorrect subject ... but | Excel Discussion (Misc queries) | |||
Incorrect Sum | Excel Discussion (Misc queries) | |||
Incorrect Sum | Excel Discussion (Misc queries) |