Quote:
Originally Posted by Excel Dumbo
Hello Dear Friends,
In desperate help.
Please refer attached excel sheet below. Could you please suggest a formula to get the count of items that fall in a specific data range ?
Any help will be greatly appreciated.
Regards,
Dumbo
|
Try this in cell B2 for one way.
Personally rather than hard code the percentages into the formula I would split column A into two and have a low and high percentage then reference those cells in the formula. This would make it easier to update if the percentages change for any reason.
For the 119% and above you would just use a COUNTIF.