percentages

sandy · Apr 29th, 2002, 11:19 AM

I'm still learning how to use formulas in excel... and still am not very good at it. I do have a question...

If I have a column of employees (J1 through J50), some who have given to a particular charitable organization... and of course, some who choose not to donate, how do I figure what percentage out of all these employees choose to donate? Is there an easy way to calculate this without using a script?

Tom Schreiner · Apr 29th, 2002, 11:40 AM

Hi Sandy...
How do you inicate who gave and who didn't?
In which Column and how?
Amount given = $0 or $SomeAmount?
An X?
That will give us enough info to help you.
Thanks,
Tom

Aladin Akyurek · Apr 29th, 2002, 11:43 AM

Quote:

On 2002-04-29 10:19, sandy wrote:
I'm still learning how to use formulas in excel... and still am not very good at it. I do have a question...

If I have a column of employees (J1 through J50), some who have given to a particular charitable organization... and of course, some who choose not to donate, how do I figure what percentage out of all these employees choose to donate? Is there an easy way to calculate this without using a script?

OK. You have the employee names in J1:J50. Where do you have data that indicates whether an employee has donated anything? Specifically, what kind of values figure there: numbers, yes/no?

Aladin

sandy · Apr 29th, 2002, 11:50 AM

If an employee has given a donation, I would enter that in the column J (J1:J50) The employees name is in column I before these columns. (for example, Joe Schmo on I20 gave $200.00 in column J20) If a number of employees don't give, I just would not enter a dollar amount and leave it blank. I just need to quickly summarize what percentage of a particular department (50 employees) gave to this organization. Thanks so much! Sandy

Aladin Akyurek · Apr 29th, 2002, 12:02 PM

Quote:

On 2002-04-29 10:50, sandy wrote:
If an employee has given a donation, I would enter that in the column J (J1:J50) The employees name is in column I before these columns. (for example, Joe Schmo on I20 gave $200.00 in column J20) If a number of employees don't give, I just would not enter a dollar amount and leave it blank. I just need to quickly summarize what percentage of a particular department (50 employees) gave to this organization. Thanks so much! Sandy

=COUNT(I1:I50)/50

You can format the cell of this formula with the Percent Style button if you want.

sandy · Apr 29th, 2002, 12:53 PM

It worked! I was so frustrated! I think I'm finally understanding this! Thanks so much!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 11:19 AM	#1
sandy New Member Join Date: Feb 2002 Location: Midwest, USA Posts: 24	I'm still learning how to use formulas in excel... and still am not very good at it. I do have a question... If I have a column of employees (J1 through J50), some who have given to a particular charitable organization... and of course, some who choose not to donate, how do I figure what percentage out of all these employees choose to donate? Is there an easy way to calculate this without using a script?

Apr 29th, 2002, 11:40 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Sandy... How do you inicate who gave and who didn't? In which Column and how? Amount given = $0 or $SomeAmount? An X? That will give us enough info to help you. Thanks, Tom

Apr 29th, 2002, 11:50 AM	#4
sandy New Member Join Date: Feb 2002 Location: Midwest, USA Posts: 24	If an employee has given a donation, I would enter that in the column J (J1:J50) The employees name is in column I before these columns. (for example, Joe Schmo on I20 gave $200.00 in column J20) If a number of employees don't give, I just would not enter a dollar amount and leave it blank. I just need to quickly summarize what percentage of a particular department (50 employees) gave to this organization. Thanks so much! Sandy

Apr 29th, 2002, 12:53 PM	#6
sandy New Member Join Date: Feb 2002 Location: Midwest, USA Posts: 24	It worked! I was so frustrated! I think I'm finally understanding this! Thanks so much!