ST Alpha - "Oh, sweet. I did not realize this. Thanks guys! -- 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 "yes, it will ignore null values and blank cells automatically. it will not ignore zeros. -- nm" by TFox

Oh, sweet. I did not realize this. Thanks guys! -- nm

Posted by Subversive Jan 18 '10, 20:06

(No message)

Responses:

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.