Averaging data within a range by day of week

Posted on 2011-10-26
Last Modified: 2012-06-21
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
Question by:GregJRob
    LVL 50

    Accepted Solution

    Hello Greg,

    Try this formula in C16 copied across and down


    see attached

    regards, barry

    Author Closing Comment


    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now