| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a range to the currently selected cells? | Excel Programming | |||
| Step through cells in a selected range | Excel Programming | |||
| Set Range Using Selected Cells | Excel Programming | |||
| Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
| max/min of a selected range of cells | Excel Programming | |||
Threaded Mode
