# COunting percent of valuess appear in provided bracket ranges

1. ## COunting percent of valuess appear in provided bracket ranges

Hi Everyone!
I have provided a data in excel in column A. In the next column I have defined certain braket ranges. I want to calculate percent of total values in Column A appearing in those specified bracket ranges.

If you see screenshot and attachment excel file then you will easily get the problem.

Excel Snapshot forum.PNG

2. ## Re: COunting percent of valuess appear in provided bracket ranges

And what happens if the profit is between 2000 and 3000??

3. ## Re: COunting percent of valuess appear in provided bracket ranges

Originally Posted by Glenn Kennedy
And what happens if the profit is between 2000 and 3000??
It should calculate the percent of values in column A in that bracket of 2000-3000.

4. ## Re: COunting percent of valuess appear in provided bracket ranges

Originally Posted by anonymous321
It should calculate the percent of values in column A in that bracket of 2000-3000.
There isn't one. See your sheet & jpg. I will add all the missing ones.

5. ## Re: COunting percent of valuess appear in provided bracket ranges

Sir, do you understand my question completely or am I missing something?

6. ## Re: COunting percent of valuess appear in provided bracket ranges

Possibly not. in your sheet and jpg, 2500 is ignored. There is NO 2000-3000 category. Also 500 is ignored. there is no 0-1000 band. Take a look at the sheet attached here... In F2, copied down:

=COUNTIFS(A:A,">="&E2,A:A,"<"&E3)/(COUNTIF(A:A,"<>")-1)

7. ## Re: COunting percent of valuess appear in provided bracket ranges

Yes you are right, I missed some information at the time of posting. However you resolved the issue very nicely. Millions Thanks

8. ## Re: COunting percent of valuess appear in provided bracket ranges

You're welcome and thanks for the rep.

There are currently 1 users browsing this thread. (0 members and 1 guests)