thnx sir...there is compulsory to change the headers.Change headers I1:N1 to 20, 30, 40, 50, 59, 99
I2: =COUNTIFS($B:$B,$H2,$D:$D,">17",$D:$D,"<="&I$1)
Copy I2: down
J2: =COUNTIFS($B:$B,$H2,$D:$D,">"&I$1,$D:$D,"<="&J$1)
Copy J2: down and across
or see attached file:
thnx u so muchNot compulsory, Just much simpler
thnx i tryIn your original file in I2:
=COUNTIFS($B:$B,$H2,$D:$D,">"&LEFT(I$1,2),$D:$D,"<"&IFERROR((FIND("&",I$1)>0)*99,(RIGHT(I$1,2)+1)))
Copy across and down