Adding text in a single column

I have a row, L3 to L200 that has this selection, Scheduled or
Unscheduled. I want the total "Scheduled" to display in cell F1 and
count as the selection is chosen from the drop down menu in column L3.

F1 - Scheduled - 31
F2 - Unscheduled - 67

I know how to sum numbers but not text and numbers. I know this isn't
that difficult, I just can't figure it out. Any assistance would
greatly be appreciated.

Thank you in advance!




--
jackel

Adding text in a single column

Try these:

="Scheduled - "&COUNTIF(L3:L200,"scheduled")

="Unscheduled - "&COUNTIF(L3:L200,"unscheduled")

--
Biff
Microsoft Excel MVP

Adding text in a single column

Hi,

I suspect you can work out how to do unscheduled:-

="Scheduled "&COUNTIF(L3:L200,"Scheduled")

Mike

Just for info to help you with your Excel problems.

Just for info to help you with your Excel problems.


L3 to L200 is a "Column" not a "row"


Gord Dibben  MS Excel MVP

Adding text in a single column

T. Valko;2640699 Wrote:


That works perfect and exactly what I wanted. Thank you so much, have a
great day!!




--
jackel

Adding text in a single column

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP