Creating a chart based on the # of times a word appears in the data

preachermjs

New Member
Joined
Jul 16, 2012
Messages
10
In the past I have created a spreadsheet which automatically charted how often a specific word appeared in the data. It's been so long since I created it that I can't remember how I did it and have no idea how to duplicate it again. The formula I used is =SUM(IF('Referral Log'!G3:G64="United Healthcare",1, 0)) but when it appears in the table it appears as
{=SUM(IF('Referral Log'!G3:G64="United Healthcare",1, 0))} I can't get this to work now!!! Help!!! I'm creating a marketing log for hospitals. So every time someone selects Via Christi for instance I want the table to calculate the total number of times that word was used and then chart the percentages in a pie chart against all of the other options. Also I want those options which aren't ever selected to simply disappear from the pie chart. How do I do all this?
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,719
Office Version
  1. 365
Platform
  1. Windows
Enter your formula with CTRL-SHIFT-ENTER.
The {} indicates this is an array formula.
 

preachermjs

New Member
Joined
Jul 16, 2012
Messages
10
Enter your formula with CTRL-SHIFT-ENTER.
The {} indicates this is an array formula.

Are you saying that after I enter the formula, instead of just pressing "enter", I hold down CTRL+SHIFT+ENTER? What sequence in other words do I do this? Thanks for the help!
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,719
Office Version
  1. 365
Platform
  1. Windows
Yes you need to enter the formula by holding down CTRL-SHIFT-ENTER.
If you just press enter you will get the wrong answer or an error.

If you have already entered the formula with enter then.
Press F2 for edit.
Then press CTRL-SHIFT-ENTER
If you do it right Excel will put the {} around the formula.
 

preachermjs

New Member
Joined
Jul 16, 2012
Messages
10
Yes you need to enter the formula by holding down CTRL-SHIFT-ENTER.
If you just press enter you will get the wrong answer or an error.

If you have already entered the formula with enter then.
Press F2 for edit.
Then press CTRL-SHIFT-ENTER
If you do it right Excel will put the {} around the formula.

THANK YOU SOOOO MUCH! Do you know the answer to the rest of my original question - how do I get my pie charts to ignore the 0%s so that they don't even show in my charts?
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,719
Office Version
  1. 365
Platform
  1. Windows
You're welcome.
I'm not sure on how to solve he 2nd part of your question.
You may want to start a new thread for it.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,207
Messages
5,594,840
Members
413,944
Latest member
3xc3ln00b

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top