Exceller 5000
New Member
- Joined
- Jan 29, 2006
- Messages
- 2
In pod-- sorry --netcast 
episode 177, it was mentioned that COUNTA could count anything but blank. But what wasn't mentioned was that there's a function called COUNTBLANK which obviously counts the number of blank cells. Say if I enter =countblank(01:07) in O8, it returns 7. If I then enter a 5 into O4, COUNTBLANK will return 6 instead. See below
Sorry for those who think this is RAND, I was just watching old eps today and I thought it could be noted.
episode 177, it was mentioned that COUNTA could count anything but blank. But what wasn't mentioned was that there's a function called COUNTBLANK which obviously counts the number of blank cells. Say if I enter =countblank(01:07) in O8, it returns 7. If I then enter a 5 into O4, COUNTBLANK will return 6 instead. See below| Book2 | ||||||
|---|---|---|---|---|---|---|
| O | P | Q | R | |||
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| 4 | 5 | |||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | 6 | |||||
Sheet1 | ||||||
