Software602 Home . products . download . support . register . how to buy . . view cart . . . contact us . . . .
Software602 Home . . . . . .
. .
.
.
Software602 Login
E-mail:
Password:
forgot?
.
Support Home .
.
User Forum .
.
Knowledge Base .
.
Submit Ticket .
.
View My Tickets .
.
. .
.
602PC SUITE 4.2 User Forumforum home | rss | search | terms of use
BackBack to 602PC SUITE 4.2 Forum
Add New TopicAdd New Topic
Post ReplyPost Reply
Countif problems
  Posted by  Dave White  on Thursday, November 06, 2003 at 6:40:09 PM (EST)
In the example below, I would like to average column A. I think I should use the 'Countif' to supply the divisor, as in =Sum(A1:A7)/Countif(K6:K12,">0"). It appears as though the Countif counts the "S's" and gives an answer of .16 instead of .98.

How do I get the average of column A?

A B
1 0.98
2
3 S
4 S
5 S
6 S
7 S
8 =Sum(A1:A7)/Countif(K6:K12,">0")
  Posted by Hans Frei  on Friday, November 07, 2003 at 4:49:13 AM (EST)
Hi Dave
I don't understand your formula (cell K ?).
If I want to know the average of A1-A7, I've the function "average(a1:a7)" and the result is 4.
For the average of your column B
the formula is "average(b1:b7)" and the result is 0.98 as your mentioned.
The average-function returns arithmetic mean of all numbers within the list.
Regards
Hans
  Posted by Dave White  on Friday, November 07, 2003 at 11:45:04 AM (EST)
Hans,
I gotta love the simple answers. Thank you. I have gone from Excel, to Easy Office, through QuattroPro, and am now trying 602Tab, all within the last three weeks. With the other spreadsheets, if I use AVERAGE, they error on having text in the column.

Thanks again,
Dave
BackBack to 602PC SUITE 4.2 Forum
Add New TopicAdd New Topic
Post ReplyPost Reply
.
. . .
.
  © 2009 Software602, Inc. All rights reserved.