| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
average in non-continuous set, excluding blanks
I want to calculate the average of non-adjacent cells (ie "=average(A3, D3,
G3, J3)"). In some cases there are blank cells in the set. How do I prevent these blank cells from being counted as zeros? I do not want them included in the average. I have only found instructions on how to do this when the set is continuous (ie "=average(A1:A10)"). Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging excluding blanks--Multiple Tabs | Excel Worksheet Functions | |||
| Count IF excluding blanks or zeroes | Excel Worksheet Functions | |||
| Using Excel as a Gradebook:Calculating sum excluding blanks and ze | Excel Discussion (Misc queries) | |||
| Excluding 0s and blanks from a LINEST function | Excel Worksheet Functions | |||
| How to get lowest value excluding blanks | Excel Worksheet Functions | |||
Threaded Mode
