+ Reply to Thread
Results 1 to 3 of 3

Total of two separate AVERAGEIF formulas

  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    10

    Total of two separate AVERAGEIF formulas

    Hi all,
    I have two columns each returning averageifs formulas of data on a different sheet.

    An example of this formula is:
    =IFERROR(AVERAGEIFS('Data Sheet'!D:D,'Data Sheet'!A:A,'Main Sheet'!B8),"")

    These work fine, no issues however, I want a third column that gives the sum of these two averages.

    I try using a simple =IFERROR((A1+B1),"") formula, but I only get a result when there is a figure in BOTH columns.
    If I use a basic =A+B, I get #VALUE! unless both cells contain data.

    Is there a way to count both, regardless of whether there is data in both cells?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Total of two separate AVERAGEIF formulas

    =sum(a1:b1)

    Perhaps

  3. #3
    Registered User
    Join Date
    10-27-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Total of two separate AVERAGEIF formulas

    YES! Thank you davsth
    This is the fix!

+ 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. Separate Out and Total
    By Sharp2k in forum Excel General
    Replies: 4
    Last Post: 09-22-2015, 08:11 PM
  2. AverageIF formulas - How can the same be done but for MAXIF or MINIF?
    By Davie18 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-11-2015, 03:03 PM
  3. Can a PivotTable separate 20% of a total?
    By Iceman1988 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-25-2013, 10:41 AM
  4. How to total separate words formula
    By DODGE in forum Excel General
    Replies: 7
    Last Post: 05-31-2011, 02:55 AM
  5. How can I total to separate wksheet
    By dustyv in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-09-2010, 02:34 PM
  6. Speed up a 100k AverageIf formulas
    By Coaster in forum Excel General
    Replies: 5
    Last Post: 08-04-2010, 02:09 AM
  7. [SOLVED] SUM total into separate worksheet
    By Martin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2006, 05:35 PM

Tags for this Thread

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