sum cells

[Guest]

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!

 

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

Biff

 

[Guest]

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.