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
Yesterday's Date Function in Excel
Using Tomorrow date function in Excel
PI circumference formula
Previous month date function in Excel
One week ago date function in Excel
Convert Number to Words (Indian Format)
SIN, COS and TAN Formulas
Year function
Date
Removing spaces
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