A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

COUNTIF Function



 
 
Thread Tools Display Modes
  #1  
Old April 19th, 2010, 07:14 PM posted to microsoft.public.excel.worksheet.functions
csmith13
external usenet poster
 
Posts: 4
Default COUNTIF Function

I am trying to use the countif function by rows and it is not calculationg
correctly. I try to drag the formula down and it just repeats the same value
as the origin cell. Is there some type of malfunction with tis function?
  #2  
Old April 19th, 2010, 07:21 PM posted to microsoft.public.excel.worksheet.functions
Luke M[_4_]
external usenet poster
 
Posts: 451
Default COUNTIF Function

It would help immensely if you had posted your formula for us to evaluate.
Without it, my best guess would be that your formula currently looks
something like:
=COUNTIF($1:$1,"My value")

when it should be:
=COUNTIF(1:1,"My value")

--
Best Regards,

Luke M
"csmith13" wrote in message
...
I am trying to use the countif function by rows and it is not calculationg
correctly. I try to drag the formula down and it just repeats the same
value
as the origin cell. Is there some type of malfunction with tis function?



  #3  
Old April 19th, 2010, 07:31 PM posted to microsoft.public.excel.worksheet.functions
Mitch
external usenet poster
 
Posts: 159
Default COUNTIF Function

Hi,

why don't you try locking the range with $ signs. Or perhaps you could send
a sample so I could take a look at what you want to do.

"csmith13" wrote:

I am trying to use the countif function by rows and it is not calculationg
correctly. I try to drag the formula down and it just repeats the same value
as the origin cell. Is there some type of malfunction with tis function?

  #4  
Old April 19th, 2010, 07:43 PM posted to microsoft.public.excel.worksheet.functions
csmith13
external usenet poster
 
Posts: 4
Default COUNTIF Function

how do i send you the file?

"Mitch" wrote:

Hi,

why don't you try locking the range with $ signs. Or perhaps you could send
a sample so I could take a look at what you want to do.

"csmith13" wrote:

I am trying to use the countif function by rows and it is not calculationg
correctly. I try to drag the formula down and it just repeats the same value
as the origin cell. Is there some type of malfunction with tis function?

  #5  
Old April 19th, 2010, 07:50 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default COUNTIF Function

Have you got calculation mode set to manual instead of automatic?
But otherwise, tell us the formula and we can see what's wrong.
--
David Biddulph


"csmith13" wrote in message
...
I am trying to use the countif function by rows and it is not calculationg
correctly. I try to drag the formula down and it just repeats the same
value
as the origin cell. Is there some type of malfunction with tis function?



  #7  
Old April 19th, 2010, 08:12 PM posted to microsoft.public.excel.worksheet.functions
csmith13
external usenet poster
 
Posts: 4
Default COUNTIF Function

here is my formula. It did not have the absolute value in it.
=COUNTIFS(C24:R24,"=1.0")

"Luke M" wrote:

It would help immensely if you had posted your formula for us to evaluate.
Without it, my best guess would be that your formula currently looks
something like:
=COUNTIF($1:$1,"My value")

when it should be:
=COUNTIF(1:1,"My value")

--
Best Regards,

Luke M
"csmith13" wrote in message
...
I am trying to use the countif function by rows and it is not calculationg
correctly. I try to drag the formula down and it just repeats the same
value
as the origin cell. Is there some type of malfunction with tis function?



.

  #8  
Old April 19th, 2010, 08:31 PM posted to microsoft.public.excel.worksheet.functions
csmith13
external usenet poster
 
Posts: 4
Default COUNTIF Function

THANK YOU! I had no idea that muy calculation was onmanual. I have never
had that problem before but it was the issue.

Thank you again!

"David Biddulph" wrote:

Have you got calculation mode set to manual instead of automatic?
But otherwise, tell us the formula and we can see what's wrong.
--
David Biddulph


"csmith13" wrote in message
...
I am trying to use the countif function by rows and it is not calculationg
correctly. I try to drag the formula down and it just repeats the same
value
as the origin cell. Is there some type of malfunction with tis function?



.

  #9  
Old April 19th, 2010, 09:06 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default COUNTIF Function

Glad it did the trick.

One way that manual can be set is if the first workbook you open in an Excel
session is one which has been saved in manual. Other workbooks opened in
the same session will then be treated as manual.
--
David Biddulph


"csmith13" wrote in message
...
THANK YOU! I had no idea that muy calculation was onmanual. I have never
had that problem before but it was the issue.

Thank you again!

"David Biddulph" wrote:

Have you got calculation mode set to manual instead of automatic?
But otherwise, tell us the formula and we can see what's wrong.
--
David Biddulph


"csmith13" wrote in message
...
I am trying to use the countif function by rows and it is not
calculationg
correctly. I try to drag the formula down and it just repeats the same
value
as the origin cell. Is there some type of malfunction with tis
function?



.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:31 PM.


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