Ignoring everything but numbers
Posted by Rich T on October 08, 2001 6:00 AM
I have a large spreadsheet with multiple formulas and links. I wish to find the average of a row containing some DIV#! cells and some blanks. I've tried SUMIF in conjunction with COUNT, AVERAGEA, etc. but no success. I can not just add a ">0" criteria because I have some negative values and as soon as I use "<>0" the formula includes the DIV#!s and it all goes wrong.
I'd like to make any cells that don't contain a number blank but I don't know how to combine 'IF' statements!
Thanks in advance!