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

Hi Pash09,

where you want to put that certain date... and where you want to display the result?

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Pash09,

If I go to category1 sheet and take the average of C3:C35 which are there on the right side of 18th April, the result is 16... how are you getting 14?

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Pash09,

Now the average of the scores against 18-04-2012 in Phone sheet is 15.. but you have shown 14.... ?
Are we on right track...?

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Pash09,


I have figured out the dates which you have are all text... column B in the sheet "Phone".. though the format is appearing to be dd/mm/yyyy hh:mm am/pm.
Any chance you could correct those, else will insert a new column which will pick up the date from column B and then this column will be used to get the desired average. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Pash09,

You can use the below formula:-
=AVERAGEIF(Phone!$C$3:$C$366,Daily!C2,Phone!$D$3:$D$366)
Dilipandey(1).xlsx

Before this, you need to include one extra column in each sheet - like I have included in Phone sheet. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

You are welcome..

Cheers

Please mark this thread as [SOLVED]. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>