| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i count text and display it as text plus the # times it hap
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i count text and display it as text plus the # times it hap
="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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| Resetting default row height to allow display of wrapped text | New Users to Excel | |||
| Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
| large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
| display multiple lines of text within a merged cell automatically | Excel Worksheet Functions | |||
Hybrid Mode
