|
You must be a logged in user to report a bad post!
| Posted By |
Message |
pharmcat2000
Mom of 2 + 1
Member since 10/05 7395 total posts
Name:
Catherine
|
Need Excel help
If I have a list of numbers, and I need to find out what percentage of them are above and below a particular value, how do I program/set Excel to figure that out for me? (For example, 15 numbers ranging from 1.12 to 3.69, and I want to know how many are 2.0 to 3.0). Or is it just easier to do it by hand?
|
Posted 3/22/16 3:34 PM  |
| |
|
Long Island Weddings
Long Island's Largest Bridal Resource |
JennP
LIF Adult
Member since 10/06 3986 total posts
Name:
Jenn
|
Re: Need Excel help
Posted by pharmcat2000
If I have a list of numbers, and I need to find out what percentage of them are above and below a particular value, how do I program/set Excel to figure that out for me? (For example, 15 numbers ranging from 1.12 to 3.69, and I want to know how many are 2.0 to 3.0). Or is it just easier to do it by hand?
You need a COUNTIFS statement.
Let's say your data is in cells a1 - a7
=COUNTIFS(A1:A7,">2",A1:A7,"<3")
It's basically range, criteria, range, criteria.
That will return the number of cells in that range that meet both criteria.
|
| Posted 3/22/16 3:52 PM |
| |
|
pharmcat2000
Mom of 2 + 1
Member since 10/05 7395 total posts
Name:
Catherine
|
Re: Need Excel help
Posted by JennP
Posted by pharmcat2000
If I have a list of numbers, and I need to find out what percentage of them are above and below a particular value, how do I program/set Excel to figure that out for me? (For example, 15 numbers ranging from 1.12 to 3.69, and I want to know how many are 2.0 to 3.0). Or is it just easier to do it by hand?
You need a COUNTIFS statement.
Let's say your data is in cells a1 - a7
=COUNTIFS(A1:A7,">2",A1:A7,"<3")
It's basically range, criteria, range, criteria.
That will return the number of cells in that range that meet both criteria.
Thank you!! 
|
| Posted 3/22/16 4:16 PM |
| |
|
Potentially Related Topics:
Currently 621900 users on the LIFamilies.com Chat
|
Long Island Bridal Shows
|
