Adding text in a single column

  • Thread starter Thread starter jackel
  • Start date Start date
J

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
 
Try these:

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

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

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

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

Mike
 
T. Valko;2640699 said:
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
-
Click to expand...


That works perfect and exactly what I wanted. Thank you so much, have
great day!
 
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
 
Back
Top