Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula that counts all data in rows including blanks 3

Status
Not open for further replies.
Mar 6, 2003
157
0
0
JO
Is there any formula that exists in Excel that counts all data including any other info, and blanks?

For example:

COUNT would count the cells with data
COUNTA would count cells with any other info

I actually need a formual that would count all info in cells including empty cells in a specific range.

Any help is greatly appreciated.

Thanks,
Shawn
 
You're welcome :)

----------------------------------------------------------------------------
[peace]It's easier to beg forgiveness than ask permission[2thumbsup]

----------------------------------------------------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top