IF Function error #VALUE

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Hello -

I searched the archives and could not find any examples on this.

The following IF statement works if I type out the address of each
cell individualy (CV12+CW12+CX12....) but I get an error message when
I try to sum the cells as a group =IF(CV12:DD12>0,CV12:DD12),
(BD14*CF12/100)+(BJ12*CU12/100)).

The reason I think the error is where it is - is because I evaluated
the function and it gives me the #VALUE after it highlights the
(CV12:DD12).

There are formulas in the cells I am trying to sum and at the moment
all of the cells equal zero. The cells are formatted as accounting
numbers.

Any help would be appreciated!
Thank you!
Pat
 
In order to Sum a range, stick in the SUM function.

=IF(SUM(CV12:DD12)>0,SUM(CV12:DD12).........



Gord
 
Gord Dibben said:
In order to Sum a range, stick in the SUM function.

=IF(SUM(CV12:DD12)>0,SUM(CV12:DD12).........
Click to expand...
....

What if the sum were negative? More robust to use

=IF(COUNT(CV12:DD12),SUM(CV12:DD12),...)
 
Back
Top