| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT gives incorrect total
Hi Experts:
This is my formula: =SUMPRODUCT(--('SP TCS REPORT'!H2:H10000="ACS-Prince George"),--('SP TCS REPORT'!I2:I10000="Count of Observations"0)) The total of records should be 182 but this formula displays 179 There is no hidden data and the naming conventions for ACS-Prince George and Count of Observations are exactly the same through the entire document. Can you tell me what might be wrong with this formula? Thank you for any help you can provide, -- jeannie v |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incorrect total of calculated field in pivot table | Excel Discussion (Misc queries) | |||
| SUMPRODUCT is giving incorrect number | Excel Discussion (Misc queries) | |||
| My autosum total is incorrect - what is wrong? | Excel Discussion (Misc queries) | |||
| Anyone seen Pivot Tables with incorrect detail but correct total? | Excel Discussion (Misc queries) | |||
| Incorrect total | Excel Worksheet Functions | |||
Threaded Mode
