IF Function error #VALUE

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
 
G

Gord Dibben

In order to Sum a range, stick in the SUM function.

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



Gord
 
H

Harlan Grove

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),...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if function help 3
#value! error in sum function 8
IF Function -- Return Null Value Help 2
#VALUE! error when trying to add cells (VLOOKUP) 6
SUM function that ignores "#VALUE" and error entries?? 2
Random #VALUE! error in simple SUM formula results 3
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4
Sum of cell which use if array function 1

Top