Formula- Count of items that meet a specific range criteria

**Excel Dumbo** · 12-05-2012, 12:39 AM

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

**Moo the Dog** · 12-05-2012, 12:59 AM

This will get you cell B2: =SUMPRODUCT((B$17:B$25>=0.72)*(B$17:B$25<=0.849))

You can adjust the values as necessary down the rows for higher percentages.

- Moo

**Moo the Dog** · 12-05-2012, 01:06 AM

Since I am bored...

These can be entered in the appropriate cells, then copied right:

B2: =SUMPRODUCT((B$17:B$25>=0.72)*(B$17:B$25<=0.849))
B3: =SUMPRODUCT((B$17:B$25>=0.85)*(B$17:B$25<=0.899))
B4: =SUMPRODUCT((B$17:B$25>=0.9)*(B$17:B$25<=0.999))
B5: =SUMPRODUCT((B$17:B$25>=1)*(B$17:B$25<=1.099))
B6: =SUMPRODUCT((B$17:B$25>=1.1)*(B$17:B$25<=1.18))
B7: =COUNTIF(B$17:B$25,">=1.19")

- Moo