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