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 |
#2
|
|||
|
|||
Use the worksheet function CountA
HTH, Gary Brown "Debra" wrote in message ... 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 |
#3
|
|||
|
|||
Hi Debra,
Use the built in Average function which ignores non-numerical values. --- Regards, Norman "Debra" wrote in message ... 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 |
#4
|
|||
|
|||
Thank you. Debra.
-----Original Message----- 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 . |
#5
|
|||
|
|||
I think you meant COUNT. COUNTA will also count non-numbers.
Jerry Gary Brown wrote: Use the worksheet function CountA HTH, Gary Brown "Debra" wrote in message ... 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 |
Reply |
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 |