+ Reply to Thread
Results 1 to 6 of 6

Nested AverageIFS to replace pivot

  1. #1
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    200

    Nested AverageIFS to replace pivot

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    200

    Re: Nested AverageIFS to replace pivot

    The Screenshots did not appear so I added them as attachments.
    Attached Images Attached Images
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,984

    Re: Nested AverageIFS to replace pivot

    It would help us to help you if you'd upload the actual spreadsheet from which the screenshots were made.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  4. #4
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    200

    Re: Nested AverageIFS to replace pivot

    they are already uploaded on the first post made.

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Nested AverageIFS to replace pivot

    and don't quote your own text by CODE like in post #1

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,984

    Re: Nested AverageIFS to replace pivot

    Perhaps this will be of some help.
    I inserted a 'Qtr.' column (B) that populates based on a table in column AA:AB the last argument of the AVERAGEIFS function references the value in column B.
    Note: I set ranges for evaluation purposes, it should still work with whole columns (but my old laptop freezes when evaluating that way).
    Let us know if you have any questions.
    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. Find and Replace with nested If?
    By kvarner in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2015, 05:09 PM
  2. VBA to replace lengthy Nested IF statements
    By Hootywho in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-24-2015, 02:38 AM
  3. Averageifs returns #DIV/0! - replace with 0?
    By CP1278 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-14-2012, 10:16 AM
  4. UDF to replace Nested Ifs
    By tom.hogan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2011, 03:52 PM
  5. Need UDF to replace nested IFs with Case
    By tom.hogan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2011, 08:07 AM
  6. 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
  7. Replace nested IF with other formulae...
    By contaminated in forum Excel General
    Replies: 3
    Last Post: 08-08-2009, 04:04 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