| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Criteria average ignoring blanks
Hi
Further to my post from yesterday I now have another question Coulmn A is a list of locations Coulmn B is a figure Sometimes Column B is empty as location was not online and no data received I need to average out the numbers in column B when a set location is in column A. I need to disregard column B if it is blank . A zero is a valid value in this Column. How do I do this in Excel 2000? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring blanks from Column(s) | Excel Worksheet Functions | |||
| Ignoring blanks and consolidating | Excel Discussion (Misc queries) | |||
| Ignoring blanks | Excel Discussion (Misc queries) | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| Conditional Average Ignoring Blanks | Excel Worksheet Functions | |||
Threaded Mode
