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.
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.
Try changing the formula that creates the #value! error so it doesn't. ieOriginally Posted by cs_vision
=if(a1=0,"",a2/a1)
Matt
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks