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 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

Try these:

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

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

--
Biff
Microsoft Excel MVP


"jackel" 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 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

T. Valko;2640699 Wrote:
Try these:

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

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

--
Biff
Microsoft Excel MVP


"jackel" 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 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
-


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




--
jackel

"jackel" wrote in message
...

T. Valko;2640699 Wrote:
Try these:

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

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

--
Biff
Microsoft Excel MVP


"jackel" 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 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
-


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




--
jackel

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

Hi,

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

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

Mike

"jackel" wrote:


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 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

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