Averaging data within a range by day of week

I am trying to collect "True" data within a date range and display this by day of week. For all "True" conditions, I need a formula that will
1) give "True" a "1" value;
2) collect this value by day of week;
3) show the average times for each given day the value was true

For instance, of the five (5) Tuesdays in a given month, an individual remembered there cellphone 3 out of five days for an average of 0.60 times per Tuesday.

I've attached a worksheet showing how I capture data and how I need it displayed.


Greg~ tracking.xlsx
Who is Participating?
barry houdiniCommented:
Hello Greg,

Try this formula in C16 copied across and down


see attached

regards, barry
GregJRobAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.