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!.

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!.

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!.