Summary of info

[pontiac]

I want to summize my data, the dates run in column A and error data runs down columns B,C,D,E,F,G.
I need to look at data daily, weekly, monthly and quarterly. So if I enter a Start date in E1 and end date in G1, and I need that to look at the data in Band return how many errors for first shift in column B and the answer goes in K2.
Now I need to be able to look at data daily so in I enter that date in E1 it will show me all the data for that day.. and if I have to enter the same date in E1 and G1 for the daily thats fine, but, I also need to be able to enter dates in E1 and G1 that will also give me Weekly, monthly, quarterly and yearly data also..

 

[Aladin Akyurek]

Try to post a sample of 10 rows from A:C (thus: not everything) along with the desired results.