Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 1st 04, 02:32 AM
Debra
 
Posts: n/a
Default 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   Report Post  
Old November 1st 04, 02:55 AM
Gary Brown
 
Posts: n/a
Default

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   Report Post  
Old November 1st 04, 03:20 AM
Norman Jones
 
Posts: n/a
Default

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   Report Post  
Old November 1st 04, 04:02 AM
 
Posts: n/a
Default

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   Report Post  
Old November 1st 04, 01:22 PM
Jerry W. Lewis
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
weighted average in pivot table nasser Excel Discussion (Misc queries) 3 January 18th 06 04:36 PM
How to Get Sum of the Average in Pivot Table? Evanya Excel Discussion (Misc queries) 1 January 6th 05 09:07 PM
IF Statement with Average Function results in #Value! Paul Excel Discussion (Misc queries) 5 December 28th 04 08:11 AM
Average Macro Christopher Anderson Excel Discussion (Misc queries) 2 December 22nd 04 06:43 PM
Average Formula Vinaya Excel Worksheet Functions 1 October 29th 04 01:53 PM


All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017