Count the number of times a specific text appears in column D

I need a formula or macro for cell C4:

Count the number of times "Dave's Auto" appears in D3 - D300 which is located in worksheet "2011".

Thanks for any help :-)

Perhaps:

=Countif('2011'!D3:D300,"Dave's Auto")

If you want to count the number of cells that contain: Dave's Auto
try something like this:
=Countif('2011'!D3:D300,"*Dave's Auto*")

or this referenced version:
A1: (text to find....eg Dave's Auto)
B1: =Countif('2011'!D3:D300,"*"&A1&"*")

Does that help?