| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
"Myrna Larson" wrote...
.... How about COUNT instead? =IF(COUNT(D3,F3,H3,J3,K3,L3,N3)=0,0,AVERAGE(D3,F3 ,H3,J3,K3,L3,N3)) .... Or use brute force. =SUM(D3,F3,H3,J3,K3,L3,N3)/MAX(1,COUNT(D3,F3,H3,J3,K3,L3,N3)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| html to excel | Excel Discussion (Misc queries) | |||
| Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
| Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| Shortcut file fails to open | Excel Discussion (Misc queries) | |||
Threaded Mode
