| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx
The following calculation =SUM(IF(H4:H39="Monthly BS",G4:G39,0))
(and several others like it) used to work, but I rearranged the data and corrected the ranges for the functions and now they don't work. When I click on fx in the toolbar to walk through the function arguments, the correct "Formula Result =" is displayed. But, when I click on the check mark it goes back to #VALUE!. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Anyone seen Pivot Tables with incorrect detail but correct total? | Excel Discussion (Misc queries) | |||
| Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
| sum of total hours not correct | Setting up and Configuration of Excel | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
| Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions | |||
Threaded Mode
