sum cells

S

SteveD

I am trying to total employee schedule so some cell have D/O day off, R/O
requested off, so when I try to total all associates by the day I get #VALUE!
in cell and total cell. Is there a way to total only numbers and ignore
#VALUE!
 
B

Biff

Try this:

=SUMIF(A1:A10,"<>#VALUE!")

Why not fix the formula that causes the error in the first place?

What is the formula that does this:
when I try to total all associates by the day I get #VALUE!
Click to expand...

Biff
 
K

Ken Wright

In line with Biff's reply, you should ALWAYS try and fix your data at source,
rather than implement workarounds to cater for error values.
 
Top