# 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
###### Who is Participating?

Commented:
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

Author 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.