| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average determination
Dear all,
I have rows of numbers which I need to average. The trouble is not all entries are numbers. I only want to average the numbers present. I have: SUM(A1:A20)/COUNTIF(A1:A20, ?) I get stuck on the criteria. How do I say in excelspeak "is a number"? regards Debra |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weighted average in pivot table | Excel Discussion (Misc queries) | |||
| How to Get Sum of the Average in Pivot Table? | Excel Discussion (Misc queries) | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
| Average Macro | Excel Discussion (Misc queries) | |||
| Average Formula | Excel Worksheet Functions | |||
Threaded Mode
