IF and ISBlank for a selected range of cells
Using Excel 207 and want to search in a particular range (A1:A31) to
determine if all cells are blanks, [true] would return a blank, [false] would
sum the range (A1:A31) then divide by number of hits within that range.
A
1 25
2
3 100
4 75
... 25
30 49
31 89
How would I write the formula? Unable to define range names because of the
size of data and updates to date. I tired this, but it doesn't work.
=+IF(ISBLANK(A1:A31),"",SUM(A1:A31)/31)
Thanks
|