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.