Summing cells in a range that has #VALUE!
Thank you
"Ragdyer" wrote:
Try this:
=SUMIF(A1:A8000,"<#value!")
Of course, the correct thing to do is to correct the errors in the column.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cs_vision" wrote in message
...
I have a range of 8000 cells that contain #VALUE!, I need to find the sum
for the cells contained in the range with numbers.
|