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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
count in Excel
- Thread starter liglin
- Start date
Penelope,
A B C D E F
1 35 42 No 12 01/01/01 TRUE
'Count' counts the numbers or numerical values
=Count(A1:F1) returns 4
'CountA' return numbers, text & logical values
=CountA(A1:F1) returns 6
'CountIF' count things that match a criteria
=CountIf(A1:F1,"No"
returns 1
Check out the Excel help for more info. Store300
Store300@ftnetwork.com
A B C D E F
1 35 42 No 12 01/01/01 TRUE
'Count' counts the numbers or numerical values
=Count(A1:F1) returns 4
'CountA' return numbers, text & logical values
=CountA(A1:F1) returns 6
'CountIF' count things that match a criteria
=CountIf(A1:F1,"No"
returns 1Check out the Excel help for more info. Store300
Store300@ftnetwork.com
- Status