Excel COUNTA Function



techstore
LQ Net Home
Access

ADO

Excel

Object Model

Workbooks in VBA

Worksheets in VBA

Open File (VBA)

SaveAs File (VBA)

Read Folder (VBA)

Ranges (VBA)

Sum Product

Index

Match

Choose

VLookup

HLookup

CountA

SumIf

JavaScript

PowerPoint

VB VBA

XML






   Excel Links
 Excel-VBA
 Excel Help
 Contextures
 Excel Tutorial
 XL_Logic
 Great Excel Link
 Excel
 Excel Pages
 Exel VBA Tips
 Excel User
 Better Solutions
 Excel Colors
 Excel Tips
 Excel VBA Examples
 C. Pearson Excel
 Add-Ins
 Apps Pro
 Business Functions
 ASAP Utilities
 J Walkenbach
 PowerUtils
 Spinnaker Add-ins
 VBA Links
 XL Logic
 Tips and Add-ins
 ExApp
 Mr. Excel



CountA Worksheet Function

printpage    Printer Friendly Page

Returns the number of non-blank cells in a range.

It will count text blanks like cell A6 and logical values like A4.

SYNTAX: =CountA(value1, value2, . . . )


Example:
=COUNTA(A1:A6) returns 6.

  A B
1     300         
2     Chicago         
3              
4     TRUE         
5     1500         
6     " "         



























   Today's News





Office Depot, Inc

Tech Depot - An Office Depot Co.



Overstock.com, Inc.

























Copyright © 2006-2008, LQ Systems,Inc. All rights reserved.