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
Bookmarks