How to find the count containing multiple query

[Arup Dutta Chowdhury]

I have got a excel sheet where there are three columns:
1) Zone
2) Department
3) Different dates where query is raised

Now I want to extract a report where it will show in East/West Zone for finance department how many queries were raised between 11/12/16 to 18/12/16. Please help me.

 

[xlstime]

Hi,

You can create a pivot table for the same. please refer enclosed for your reference.

I have got a excel sheet where there are three columns:
1) Zone
2) Department
3) Different dates where query is raised

Now I want to extract a report where it will show in East/West Zone for finance department how many queries were raised between 11/12/16 to 18/12/16. Please help me as it is urgently required.

 

[AVK]

Apart from Pivot. You can also do by formula. If you table with large database, then you go with Pivot. Look attach file.

 

[Arup Dutta Chowdhury]

I know I can do it through pivot but i want to do it through formula.Thank you.