SUMPRODUCT would it help to gather daily average and daily total from other sheet?

First, I wish to thank you CANAPONE arlu1201 for guiding me on how to accurately start a new post:

hello I am very new to excel and was just starting: However, I would need to sort out my excel file for my survey result tracker.

I need that on each category, everything i put on a certain date, say, on the 18th, all result on the 18 will be automatically feed on the "daily sheet" under the corresponding dates under the specific ranges:

say: for cat 1, on the 18th of Apr, i need excel to automatically show me the average and total numbers of result gathered on that day.Same as the the Per question daily average. They say sum product is best. I have attached here . April 18 and 19 data have been entered manually.TO EDIT22.xlsx

I desperately need help
Thanks so much

If am still doing this wrong, i apologiseTO EDIT22.xlsx