+ Reply to Thread
Results 1 to 1 of 1

AVERAGEIF Only Perform the Average if a Filter is Met

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    Oxford, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    AVERAGEIF Only Perform the Average if a Filter is Met

    Hi, I am new to the forum so apologies if I do anything annoying.


    I have built a spread sheet that tests the ventilation rates for rooms in a building. From the software I use I get an export of the flow rate for every hour of the day over the summer across multiple rooms.


    I need to know if the daily average goes below 5 l/s/person and for how many days. Hence the number of people in each room is an input.

    The spreadsheet I have built works fine. But it calculates the daily average for all 24 hours of the day and weekends etc.

    Ideally I would like to improve it to only consider taking a contribution to the daily average at times when the filter is equal to 1. Hence certain times and days can be filtered out.


    Does anyone know if this is possible? Ideally I would like to avoid Macros. But if they are required that is fine.

    As the sheet is for up to 100 rooms I really need to minimise extra columns.

    I just need a tweak to the formula in column D to account for the filter.


    Any help would be greatly appreciated.


    Ross
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] AVERAGEIF Formula Different then Excel Average
    By Winfield in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-30-2013, 09:13 PM
  2. [SOLVED] Excel 2010 AVERAGEIF function to average two different columns on two different tabs
    By stevemills04 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2013, 01:48 PM
  3. macro to perform average of cells
    By revan89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2012, 02:37 PM
  4. AverageIf w/a filter?
    By mattys in forum Excel General
    Replies: 0
    Last Post: 11-10-2011, 11:51 PM
  5. Another Average or AverageIf Issue
    By scarames in forum Excel General
    Replies: 6
    Last Post: 08-18-2009, 11:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1