C
cs_vision
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.
for the cells contained in the range with numbers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
=sum(if(isnumber(a1:b4000),a1:b4000))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
Adjust the range to match--but you can't use the whole column.
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
Adjust the range to match--but you can't use the whole column.
R
Ragdyer
Try this:
=SUMIF(A1:A8000,"<>#value!")
Of course, the correct thing to do is to correct the errors in the column.
=SUMIF(A1:A8000,"<>#value!")
Of course, the correct thing to do is to correct the errors in the column.
M
Mallycat
cs_vision said:I have a range of 8000 cells that contain #VALUE!, I need to find th
sum
for the cells contained in the range with numbers.
Try changing the formula that creates the #value! error so it doesn't.
ie
=if(a1=0,"",a2/a1)
Mat
C
cs_vision
Thank you
Ragdyer said:Try this:
=SUMIF(A1:A8000,"<>#value!")
Of course, the correct thing to do is to correct the errors in the column.
C
cs_vision
Thank You
Dave Peterson said:=sum(if(isnumber(a1:b4000),a1:b4000))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
Adjust the range to match--but you can't use the whole column.