ST Alpha - "Will AVERAGE(a1.a100) do that automagically? Or do you need to use the COUNTIF function? -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 157

In response to "Excel help? I want to pull data from a column, and average the results together." by Subversive

Will AVERAGE(a1.a100) do that automagically? Or do you need to use the COUNTIF function? -- nm

Posted by Dano (aka dano) Jan 18 '10, 20:03

(No message)

Responses:

You could do AVERAGE(A:A) will average the items in column A. I'm not sure what he's looking for exactly, tho. -- nm - JaxSean Jan 18, 20:06
yes, it will ignore null values and blank cells automatically. it will not ignore zeros. -- nm - TFox Jan 18, 20:05 5
- Oh, sweet. I did not realize this. Thanks guys! -- nm - Subversive Jan 18, 20:06 4
  - thought AVG (A:A) stopped at the first blank cell -- nm - lone canadian leafs fan Jan 18, 20:08 3
    - =average(a:a) will average the entire column, but skip blanks. -- nm - JaxSean Jan 18, 20:11
    - not according to the test i just did. -- nm - TFox Jan 18, 20:10 1
      - Yeah, it's working perfectly. -- nm - Subversive Jan 18, 20:13
=SUMIF and =COUNTIF then AVG would be =SUMIF / COUNTIF - lone canadian leafs fan Jan 18, 20:05

Post a message top

Replies are disabled on threads older than 7 days.