Need Formula for different bracket number.

[serge]

I need a formula in K10:K24 that will count how many numbers match the different bracket numbers table. ( See Below ).

Excel Workbook
	G	H	I	J	K
10	55,349			250,000	2
11	546,623			500,000	0
12	1,194,016			750,000	1
13	1,285,618			1,000,000	2
14	1,273,825			1,250,000	2
15	2,960,210			1,500,000	2
16	3,109,520			1,750,000	1
17	1,639,197			2,000,000	2
18	3,642,736			2,250,000	0
19	1,919,710			2,500,000	0
20	3,165,057			2,750,000	1
21	1,221,696			3,000,000	2
22	3,018,557			3,250,000	3
23	961,145			3,500,000	0
24	196,895			3,750,000	0
25	1,933,124
26	860,004
27	2,896,456
Sheet

Sorry this table below is for better understanding.


<table style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; " border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td> </td><td>G</td><td>H</td><td>I</td><td>J</td><td>K</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">10</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-style:solid; border-width:1px; border-color:#000000; ">55,349</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">0</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">250,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">2</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">11</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">546,623</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">250,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">500,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">0</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">12</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">1,194,016</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">500,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">750,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">13</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">1,285,618</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">750,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1,000,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">14</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">1,273,825</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1,000,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1,250,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">15</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">2,960,210</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1,250,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1,500,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">16</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">3,109,520</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1,500,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1,750,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">17</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">1,639,197</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1,750,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2,000,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">18</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">3,642,736</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2,000,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2,250,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">0</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">19</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">1,919,710</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2,250,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2,500,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">0</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">20</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">3,165,057</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2,500,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2,750,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">21</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">1,221,696</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2,750,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">3,000,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">2</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">22</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">3,018,557</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">3,000,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">3,250,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">3</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">23</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">961,145</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">3,250,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">3,500,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">0</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">24</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">196,895</td><td style="font-family:Arial; font-size:10pt; border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">3,500,000</td><td style="background-color:#ccffcc; font-weight:bold; font-family:Arial; font-size:10pt; text-align:right; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">3,750,000</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">0</td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">25</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">1,933,124</td><td style="font-family:Arial; font-size:10pt; "> </td><td style="font-family:Arial; font-size:10pt; "> </td><td style="font-family:Arial; font-size:10pt; "> </td><td style="font-family:Arial; font-size:10pt; "> </td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">26</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">860,004</td><td style="font-family:Arial; font-size:10pt; "> </td><td style="font-family:Arial; font-size:10pt; "> </td><td style="font-family:Arial; font-size:10pt; "> </td><td style="font-family:Arial; font-size:10pt; "> </td></tr><tr style="height:15px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">27</td><td style="font-family:Arial; font-size:10pt; text-align:center; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">2,896,456</td><td style="font-family:Arial; font-size:10pt; "> </td><td style="font-family:Arial; font-size:10pt; "> </td><td style="font-family:Arial; font-size:10pt; "> </td><td style="font-family:Arial; font-size:10pt; "> </td></tr></table>

It should look like this.
Thank you.
Serge.

 

[circledchicken]

Hi,

Are you sure those values are correct? (for example should there be a 1 in the last category?)

Maybe in K10 try:
=COUNTIF($G$10:$G$27,"<"&J10)-SUM($K$9:K9) and copy down

 

[Special-K99]

Use this formula

=SUMPRODUCT( ($G$10:$G$27 >= I10) * ($G$10:$G$27 < J10) )

and copy down the column

By the way your results are incorrect

2,500,000 - 2,750,000 There is nothing in this range
3,500,000 - 3,750,000 There is 1 item in G18 within this range

 

[serge]

Hi Thanks to both of you, that exactly what I needed, and yes I have some incorrect result, I did it to quick Sorry about that.

Serge.