Countif with cell reference
 

Hi

Hope someone can help. Is there a way to count the amount of instances less
than a certain value, but to enter this value as a reference to a cell. For
example the following:

=COUNTA(C5:C1000)/COUNTIF(B5:B1000,"h3")

Does not work but if i type in the value of h3 it does. Is there no way to
leave it as h3 so I dont have to manually enter it many (many!) times over?

Thanks....

nick

instead of "h3" which will look for the text string "h3" use ""&h3, thus


=COUNTA(C5:C1000)/COUNTIF(B5:B1000,""&H3)

should work\\


regards,

Peo Sjoblom


"Nick" wrote:

Hi

Hope someone can help. Is there a way to count the amount of instances less
than a certain value, but to enter this value as a reference to a cell. For
example the following:

=COUNTA(C5:C1000)/COUNTIF(B5:B1000,"h3")

Does not work but if i type in the value of h3 it does. Is there no way to
leave it as h3 so I dont have to manually enter it many (many!) times over?

Thanks....

nick

thanks so much, works a treat :)

"Peo Sjoblom" wrote:

instead of "h3" which will look for the text string "h3" use ""&h3, thus


=COUNTA(C5:C1000)/COUNTIF(B5:B1000,""&H3)

should work\\


regards,

Peo Sjoblom


"Nick" wrote:

Hi

Hope someone can help. Is there a way to count the amount of instances less
than a certain value, but to enter this value as a reference to a cell. For
example the following:

=COUNTA(C5:C1000)/COUNTIF(B5:B1000,"h3")

Does not work but if i type in the value of h3 it does. Is there no way to
leave it as h3 so I dont have to manually enter it many (many!) times over?

Thanks....

nick