Formula to total up text information

%3CLINGO-SUB%20id%3D%22lingo-sub-1504578%22%20slang%3D%22en-US%22%3EFormula%20to%20total%20up%20text%20information%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504578%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20turn%20text%20information%20into%20a%20value%20or%20set%20up%20a%20formula%20to%20convert%20it%20into%20a%20value%3F%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20pie%20chart%20to%20track%20my%20case%20acceptance%20in%20my%20dental%20office.%3C%2FP%3E%3CP%3EWhen%20each%20patient%20is%20seen%20they%20are%20entered%20into%20the%20spreadsheet%20(within%20this%20spreadsheet%20I%20have%2012%20workbooks%20for%20each%20month%20of%20the%20year).%26nbsp%3B%20There%20is%20an%20%22Acceptance%20Column%22%20and%20the%20drop%20down%20has%20a%20choice%20of%20%22Scheduled%22%2C%20%22Unscheduled%22%20or%20%22Completed%22.%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20excel%20to%20add%20up%20the%20total%20number%20of%20cells%20that%20have%20for%20example%20%22Scheduled%22%20in%20it%20and%20convert%20it%20into%20a%20number%20to%20use%20in%20a%20pie%20chart%20or%20just%20extract%20this%20information%20into%20a%20%22Master%20Sheet%22%20that%20I%20can%20see%20at%20a%20quick%20glance%20each%20month%20on%20this%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20there%20is%20an%20easier%20way%20to%20do%20what%20I%20am%20trying%20to%20do%2C%20I%20am%20all%20ears.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I%20am%20making%20sense%20of%20what%20I%20am%20after.%26nbsp%3B%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1504578%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Is there a way to turn text information into a value or set up a formula to convert it into a value?

I am trying to create a pie chart to track my case acceptance in my dental office.

When each patient is seen they are entered into the spreadsheet (within this spreadsheet I have 12 workbooks for each month of the year).  There is an "Acceptance Column" and the drop down has a choice of "Scheduled", "Unscheduled" or "Completed".

How can I get excel to add up the total number of cells that have for example "Scheduled" in it and convert it into a number to use in a pie chart or just extract this information into a "Master Sheet" that I can see at a quick glance each month on this sheet. 

 

If there is an easier way to do what I am trying to do, I am all ears.

 

I hope I am making sense of what I am after.  Thank you.

2 Replies
Highlighted

@Luci_B , you can use the COUNTIF function. See attached. 

Highlighted

@Luci_B Consider gathering all patient data in one single sheet and create a Pivot Table that counts patients by month and status. With a Pivot Chart you can then easily create the pie chart for the month of your choice. An example is attached.