| 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!. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx
Array enter it using CTRL+SHIFT+ENTER
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Yo!" wrote in message ups.com... 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!. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM Calculations Returns #VALUE but displays correct total with "I
try this:
ctrl+shift+enter (not just enter) in your formula "Yo!" wrote: 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!. |
| Reply |
| 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 | |||
Hybrid Mode
