View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NavyMom NavyMom is offline
external usenet poster
 
Posts: 2
Default 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