Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
Office GroupsView
Excel
Excel Charting
Excel Crashesgpfs
Excel Misc
Excel Newusers
Excel Programming
Excel Setup
Excel Worksheet Functions
Word Application Errors
Word Conversions
Word Customization Menustoolbars
Word Docmanagement
Word Drawing Graphics
Word International Features
Word Mail
Word Mailmerge Fields
Word Newusers
Word Numbering
Word Oleinterop
Word Pagelayout
Word Printingfonts
Word Setup Networking
Word Spelling Grammar
Word Tables
Word Visual Basica Addins
Word Visual Basica Customization
Word Visual Basica General
Word Visual Basica Userforms
Works Win
Office Developer Automation
Office Developer Com Add_Ins
Office Developer Officedev Other
Office Developer Outlook Forms
Office Developer Outlook Visual Basica
Office Developer Visual Basica
Office Misc
Office Setup
Officeupdate
Onenote
Outlook
Outlook Bcm
Outlook Calendaring
Outlook Contacts
Outlook Fax
Outlook General
Outlook Installation
Outlook Interop
Outlook Mac
Outlook Printing
Outlook Program_Addins
Outlook Program_Forms
Outlook Program_Visual Basica
Outlook Teamfolders
Outlook Thirdpartyutil
Project
Project Developer
Project Server
Visio
Visio Developer
Visio General
Word Visual Basica Beginners
Outlookexpress General
Office Communicator
Word Programming
Office Templates Misc

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Apps
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

View All Microsoft Excel Worksheet Functions Posts  Ask A New Question 

Adding text in a single column

jackel posted on Friday, February 22, 2008 2:57 PM

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

 

Adding text in a single column

T. Valko posted on Friday, February 22, 2008 3:09 PM

Try these:

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

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

--
Biff
Microsoft Excel MVP
reply

Adding text in a single column

Mike posted on Friday, February 22, 2008 3:12 PM

Hi,

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

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

Mike
reply

Adding text in a single column

jackel posted on Friday, February 22, 2008 5:33 PM

T. Valko;2640699 Wrote:


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




--
jackel
reply

Just for info to help you with your Excel problems.

Gord Dibben posted on Friday, February 22, 2008 7:29 PM

Just for info to help you with your Excel problems.


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


Gord Dibben  MS Excel MVP
reply

Adding text in a single column

T. Valko posted on Friday, February 22, 2008 9:47 PM

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP
reply

 
 

Previous Microsoft Excel Worksheet Functions conversation.