LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
pete the greek
 
Posts: n/a
Default counta function can any one explain the example counting 2

in help there are examples for counta

i can see what is happening when it just has 1 value ie:
a range as in the first two examples

but cant see what is happening in the third ex

a1:a6 is 6 non blanks

there are five "2" but the result is 7 not 11


A
1 Data
2 Sales
3 12/8/2008
4
4 19
6 22.24
7 TRUE
8 #DIV/0!

Formula Description (Result)
=COUNTA(A2:A8) Counts the number of nonblank cells in the list above (6)
=COUNTA(A5:A8) Counts the number of nonblank cells in the last 4 rows of the
list (4)
=COUNTA(A1:A7,2) Counts the number of nonblank cells in the list above and
the value 2 (7)
=COUNTA(A1:A7,"Two") Counts the number of nonblank cells in the list above
and the value "Two" (7)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Errors in COUNT, COUNTA, COUNTIF when counting merged cells Outback Excel Worksheet Functions 1 February 7th 06 04:29 PM
Letter Counting Function bctrophy Excel Worksheet Functions 2 December 21st 05 10:36 PM
UDF help please Adam Kroger Excel Discussion (Misc queries) 3 December 17th 05 07:21 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"