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 |
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 |
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 |
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 . |
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 |
All times are GMT +1. The time now is 04:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com