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.
Thanks in advance.
Excel Snapshot forum.PNG
And what happens if the profit is between 2000 and 3000??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
It should calculate the percent of values in column A in that bracket of 2000-3000.Originally Posted by Glenn Kennedy
There isn't one. See your sheet & jpg. I will add all the missing ones.
Sir, do you understand my question completely or am I missing something?
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)
Yes you are right, I missed some information at the time of posting. However you resolved the issue very nicely. Millions Thanks
You're welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks