Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default Counta not counting correctly!!

Ok, I'm tearing my hair out.
I have Excel 2003.
I have a very simple formula to count the number of "yes" answers in a
column but it isn't calculating correctly.
=counta(c22:c29,"*y*") should = 8 (In this instance all the answers are yes)
but instead it is returning an answer of 9.
There are no hidden rows or columns. What could cause this?
I have many other columns to apply this formula to, many of them are much
longer than this one which I can easily see isn't coming out correctly - I
need to know my formula is working correctly!
thanks, Meenie
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default Counta not counting correctly!!

Nevermind, should have used countif, lol. Where is my head today? (don't
answer that!!)

"Meenie" wrote:

Ok, I'm tearing my hair out.
I have Excel 2003.
I have a very simple formula to count the number of "yes" answers in a
column but it isn't calculating correctly.
=counta(c22:c29,"*y*") should = 8 (In this instance all the answers are yes)
but instead it is returning an answer of 9.
There are no hidden rows or columns. What could cause this?
I have many other columns to apply this formula to, many of them are much
longer than this one which I can easily see isn't coming out correctly - I
need to know my formula is working correctly!
thanks, Meenie

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Counta not counting correctly!!

Hi,

COUNTA is the wrong function, try this

=COUNTIF(C22:C29,"Yes")

or if you mean contains the string yes among other words try this

=COUNTIF(C22:C29,"*Yes*")

Mike

"Meenie" wrote:

Ok, I'm tearing my hair out.
I have Excel 2003.
I have a very simple formula to count the number of "yes" answers in a
column but it isn't calculating correctly.
=counta(c22:c29,"*y*") should = 8 (In this instance all the answers are yes)
but instead it is returning an answer of 9.
There are no hidden rows or columns. What could cause this?
I have many other columns to apply this formula to, many of them are much
longer than this one which I can easily see isn't coming out correctly - I
need to know my formula is working correctly!
thanks, Meenie

Reply
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
COUNTA counting formulas as well. Gaurav[_2_] Excel Worksheet Functions 2 February 1st 08 09:10 PM
the countA function is counting everything even empty cells ToniNolen Excel Worksheet Functions 2 September 27th 06 07:42 PM
counta function can any one explain the example counting 2 pete the greek Excel Discussion (Misc queries) 4 March 30th 06 10:27 AM
Errors in COUNT, COUNTA, COUNTIF when counting merged cells Outback Excel Worksheet Functions 1 February 7th 06 05:29 PM
COUNTA Function not working =COUNTA(C3:C69,"NH") MikeinNH Excel Worksheet Functions 2 November 8th 04 02:19 AM


All times are GMT +1. The time now is 11:06 AM.

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

About Us

"It's about Microsoft Excel"