Results 1 to 5 of 5

AVERAGEIFS gives me two different results in two tables that have same values

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2020
    Location
    Wroclaw
    MS-Off Ver
    Excel 2013
    Posts
    18

    AVERAGEIFS gives me two different results in two tables that have same values

    Hi everyone,

    In the file that I'm attaching I have two tables, the first one contains an AVERAGEIFS formula in the "Result" column that looks into Table2 to find the average number (called Average Delta) for each country and category.

    However when I compare the averages in the two tables I see different results. For example:

    if in the first table I filter by category "B", the average of the column "Result" is 63
    if in the second table I filter by category "B" the average of column "Average Delta" is 59

    Could you help me to understand why there is this difference? What can I do to align the average of Table1 ("result") with the average of Table2 ("Average Delta") ?

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Different results for =average & averageifs for same data range
    By ljbrown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2017, 05:49 PM
  2. Averageifs last n values entered
    By frousseau in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-05-2016, 01:23 PM
  3. AVERAGEIFS and identifying Numeric values
    By pjwhitfield in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-10-2015, 04:06 AM
  4. [SOLVED] Averageifs returning DIV/0 errors even though there are values
    By lifeseeker1019 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2013, 02:19 AM
  5. [SOLVED] averageifs on multiple tables/ranges
    By kpkammer in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-28-2012, 12:20 PM
  6. averageifs not picking up values
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2012, 01:27 AM
  7. Replace #DIV/0! with "0" in Averageifs function results
    By nickelcell1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-12-2010, 02:09 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