 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008Adding text in a single column
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 -- jackel Try these: ="Scheduled - "&COUNTIF(L3:L200,"scheduled") ="Unscheduled - "&COUNTIF(L3:L200,"unscheduled")  SignatureBiff Microsoft Excel MVP > 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 [quoted text clipped - 9 lines] > > Thank you in advance! T. Valko;2640699 Wrote: > Try these: > [quoted text clipped - 19 lines] > jackel > - That works perfect and exactly what I wanted. Thank you so much, have great day! -- jackel > T. Valko;2640699 Wrote: >> Try these: [quoted text clipped - 23 lines] > That works perfect and exactly what I wanted. Thank you so much, have a > great day!! You're welcome. Thanks for the feedback! SignatureBiff Microsoft Excel MVP Hi, I suspect you can work out how to do unscheduled:- ="Scheduled "&COUNTIF(L3:L200,"Scheduled") Mike > 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 [quoted text clipped - 9 lines] > > Thank you in advance! 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.