+ Reply to Thread
Results 1 to 2 of 2

AverageIfs Statement Counting Zeros

  1. #1
    Registered User
    Join Date
    09-03-2012
    Location
    In a Vortex
    MS-Off Ver
    Excel 2010
    Posts
    16

    AverageIfs Statement Counting Zeros

    Hello. I'm hoping someone can help me figure out how to properly write this formula so that it will exclude zeros in the average. The average is coming in lower than it should based on when I manually filter in the column for the same time period in the raw data. Here is the formula that I'm currently using:

    =AVERAGEIFS(Table1[Est Proj Revenue],Table1[Aggregated Status],"Lost",Table1[dtSubmitMo],VP_Mo,Table1[dtSubmitYr],VP_Yr)


    I am trying to average the estimated project revenue column [Est Proj Revenue] where the status column [Aggregated Status] indicates "Lost" for deals submitted during a particular month and year 'Table1[dtSubmitMo],VP_Mo,Table1[dtSubmitYr],VP_Yr'

    The formula is working (I've gone through several variations of the same formula and this seems close.) However, I am at a loss as to where to include the "<>" in the syntax to tell the formula to "not count zeros" in the [Est Proj Revenue] column.

    There must be something in here that can help me get the average I need for these particular records. Any ideas?

  2. #2
    Registered User
    Join Date
    09-03-2012
    Location
    In a Vortex
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: AverageIfs Statement Counting Zeros

    example 2.xlsx

    Here is a file with sample data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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