skip to main
|
skip to sidebar
Excel Geek
Thursday, October 17, 2013
COUNTA Formula - counts nonblank cells
Theory:
=COUNTA(Range)
Example:
=COUNTA(A2:A8)
The COUNTA formula counts the number of cells in a range that are not empty. it does not distinguish between different datatypes.
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
www.cineclouds.com. Powered by
Blogger
.
Popular Posts
Blog Archive
►
2021
(8)
►
June
(2)
►
April
(1)
►
March
(5)
►
2015
(4)
►
December
(1)
►
April
(1)
►
January
(2)
►
2014
(13)
►
November
(2)
►
October
(1)
►
August
(1)
►
July
(1)
►
June
(1)
►
May
(1)
►
April
(2)
►
March
(3)
►
January
(1)
▼
2013
(40)
►
December
(2)
▼
October
(6)
FORECAST Formula
COUNTA Formula - counts nonblank cells
Small Formula
Convert Formula to Number Value
Large Formula
Kurt Formula
►
April
(4)
►
March
(1)
►
February
(11)
►
January
(16)
►
2012
(38)
►
December
(3)
►
November
(12)
►
October
(22)
►
July
(1)
0 comments:
Post a Comment