how do i count text and display it as text plus the # times it hap

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
="Boxing Day occurs "&COUNTIF(A:A,"Boxing Day")&" times"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top