Desperately Help Needed - Arranging a Table like a Frequency Distribution

Hello Members,

I know this is a post which asks too much and am so desperate for solution. Let me tell you that, after going through various formulas of FREQUENCY, tried IF, COUNTIF and etc. I am not sure how to start the formula.

I am posting my excel sheet to learn how to do it by using your formula. So please please help me.

Now, the problem is, I have a table (pivot) with headings as ( 0, 4, 1, 3, 2 etc representing DAYS since the issue is OPEN) and Rows Heading with the Respective Dept. like which dept. has an issue opened since how many days kind of. I wnated to group the days like 0 days, 1 to 3 days, 4 to 7 days etc. But not knowing how to write the formula. I have attached the sheet for your reference. Kindly help me.

Thanking You

Regards
Bhargav Seeram

try this ,
paste it b15 - sheet3 , this formula is not for total column.

=SUMIFS($B2:$H2,$B$1:$H$1,">="&LEFT(B$14,2),$B$1:$H$1,IF(ISNUMBER(TRIM(RIGHT(B$14,2))*1),"<="&RIGHT(B$14,2),"<="&1000))

In B15

=SUMIFS($B$2:$B$10,$A$2:$A$10,$A15)

in C15

=SUMPRODUCT(($A$2:$A$10=$A15)*($B$1:$H$1>=1)*($B$1:$H$1<=3)*($B$2:$H$10))

Change C15 in D15 onwards compares to required limits (4-7 etc)