ST Alpha - "yes, it will ignore null values and blank cells automatically. it will not ignore zeros. -- 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 "Will AVERAGE(a1.a100) do that automagically? Or do you need to use the COUNTIF function? -- nm" by Dano

yes, it will ignore null values and blank cells automatically. it will not ignore zeros. -- nm

Posted by TFox Jan 18 '10, 20:05

(No message)

Responses:

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

Post a message top

Replies are disabled on threads older than 7 days.