="Boxing Day occurs "&COUNTIF(A:A,"Boxing Day")&" times"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Count in Excel" <Count in wrote in message
...
PromotionName UnitSales ChannelName Quarter
Boxing Day 1200 Richard 1 1
Boxing Day 1300 Will 2 2
Boxing Day 1600 Will 3 3
Boxing Day 1300 Will 3 4

I want to know how many times Boxing day occured as well as displaying the
Text "Boxing Day"

I tried SumProduct Function
I tried CountIF and combination
I tried Counta
none of them work