| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average number excluding 0 and blanks with text criteria
Hello smart people
I have a list of survey names in A3:A726 and numbers in M3:M726. Column M also contains 0 and blanks. I am doing a summary table on the next sheet so I need a formula to show if it is 'SurveyName="Manchester" then average 'Autumn 09'!M3:M726 (ignoring zeros and blanks) Any help would be greatly appreciated as this is beyond my knowledge. Many thaks Paula |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count text with specific criteria ignoring N/A and blanks | Excel Worksheet Functions | |||
| average in non-continuous set, excluding blanks | Excel Worksheet Functions | |||
| Criteria average ignoring blanks | Excel Discussion (Misc queries) | |||
| Criteria average ignoring blanks | Excel Discussion (Misc queries) | |||
| Is there a way to get an average, excluding the lowest number? | Excel Discussion (Misc queries) | |||
![Pumpkin Pie[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
