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.

Thanks,

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

Try this formula in C16 copied across and down

=COUNTIFS($C$2:$AF$2,C$15,$C3:$AF3,TRUE)/COUNTIFS($C$2:$AF$2,C$15)

see attached

regards, barry
27416875.xlsx
0
 
GregJRobAuthor Commented:
Thanks!
0
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.