Count IF Function

[corbie82]

Hi there

I have included a screenshot of the formula that I'm currently using.
View image: excel

My question is in a count if function can i reference a particular cell instead of text. If you look at the example I'm going to be using the text in cell C3 for about 20 different Count If Functions and was wondering if there was a way of doing it without having to type in the text each time.

Thanks for you help

 

[FormR]

Hi welcome to the board!

Yes, try:
=COUNTIF(Sheet2!D:D,C3)

 

[corbie82]

Hi welcome to the board!

Yes, try:
=COUNTIF(Sheet2!D:D,C3)

Brilliant thanks that works fine i was trying =C3 and "=C3" etc didn't think to try just C3 thanks a lot

 

[FormR]

Brilliant thanks that works fine

Great, thanks for letting us know.