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