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

[preachermjs]

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?

 

[AhoyNC]

Enter your formula with CTRL-SHIFT-ENTER.
The {} indicates this is an array formula.

 

[preachermjs]

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]

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]

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]

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.