Problem with COUNTIF

[hallingh]

OK, I need to get together a countif formula that only counts if BOTH specified criteria are true... This is what I thought would work:

=COUNTIF(W1:W28, AND(>A18, <A19))

But it is not letting me enter that into the cell...

Anyone have any ideas?

Any help is greatly appreciated...

Thanks!

Hank

 

[Aladin Akyurek]

OK, I need to get together a countif formula that only counts if BOTH specified criteria are true... This is what I thought would work:

=COUNTIF(W1:W28, AND(>A18, <A19))[ p CODE]<> 
But it is not letting me enter that into the cell...
 
Anyone have any ideas?
 
Any help is greatly appreciated...
 
Thanks!
 
Hank[/QUOTE]
 
Care to explain the problem in words?

 

[hallingh]

I have a range (W1:W28) that contains the formula:

=RAND() * 6

In Cell F1, I want it to count how many times there is a number between the value in cell A18 and cell A19.

Ah! Just realized the formula got cut off! It is actually:

=COUNTIF(W1:W28, AND(<A18, >A19))

THanks for the reply!

Sorry for the confusion.

Hank

 

[barry houdini]

=COUNTIF(W1:W28, AND( >A18, < A19))

If you have Excel 2007 or later try COUNTIFS

=COUNTIFS(W$1:W$28,">"&A18,W$1:W$28,"<"&A19)

or in earlier versions you can use two COUNTIF functions for the same result

=COUNTIF(W$1:W$28,">"&A18)-COUNTIF(W$1:W$28,">="&A19)

Note that "<"&A19 changes to the opposite in the second, ">="&A19 because you are subtracting

 

[hallingh]

That is perfect.

Thanks a ton for the help!