Countif question :)

[nase]

Hi there,

I am working on my countif formula for this 10 page worksheet.
I am hoping that someone can tell me how can I carry the RANGE all the way down my table, My criteria is different for every cell going down. Example: Countif(Data!A2:A995, "Back injuries")

I would like to carry the A2:A995 range all the way down the table. but excell carries this as A3:A995 and A4:A995. I would like that part to be consistant. I remember using the $ signs but I cant seem to wrap my head around this one.

Help please! Thank you

 

[jfish1288]

Try this
Countif(Data!A$2:A$995, "Back injuries")

 

[T. Valko]

Hi there,

I am working on my countif formula for this 10 page worksheet.
I am hoping that someone can tell me how can I carry the RANGE all the way down my table, My criteria is different for every cell going down. Example: Countif(Data!A2:A995, "Back injuries")

I would like to carry the A2:A995 range all the way down the table. but excell carries this as A3:A995 and A4:A995. I would like that part to be consistant. I remember using the $ signs but I cant seem to wrap my head around this one.

Help please! Thank you

Like this:

=Countif(Data!A$2:A$995,"Back injuries")

The dollar signs $ will keep the row numbers from changing when copied down.

 

[nase]

AHHHHHHHHHHHH yessssssssssssssss, thank you so much!!!!! I kept doing this $A2:$A955! ugh!

Thank you so so much.

 

[T. Valko]

AHHHHHHHHHHHH yessssssssssssssss, thank you so much!!!!! I kept doing this $A2:$A955! ugh!

Thank you so so much.

You're welcome. Thanks for the feedback!