Adding text in a single column

[jackel]

I have a row, L3 to L200 that has this selection, Scheduled o
Unscheduled. I want the total "Scheduled" to display in cell F1 an
"Unscheduled" in G1 like this if possible. This will auto update th
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'
that difficult, I just can't figure it out. Any assistance woul
greatly be appreciated.

Thank you in advance

 

[T. Valko]

Try these:

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

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

 

[Mike H]

Hi,

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

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

Mike

 

[jackel]

Try these:

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

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

--
Biff
Microsoft Excel MVP


"jackel" (e-mail address removed) wrote in message

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
"Unscheduled" in G1 like this if possible. This will auto update the
count as the selection is chosen from the drop down menu in colum
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
-

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

 

[Gord Dibben]

Just for info to help you with your Excel problems.

"I have a row, L3 to L200 that has this selection"

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


Gord Dibben MS Excel MVP

 

[T. Valko]

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

You're welcome. Thanks for the feedback!