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

C

Count in Excel

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Optimize event selection 0
Counting text 2
To Crosstab or not to crosstab 12
Calendar Logic: Recurring Dates 3
Count number of times a text occurs 3
Creating an attendance sheet EXCEL 0
Union and group, then count 1
How do I count non blank rows only? 3

Top