+ Reply to Thread
Results 1 to 6 of 6

Condition question on MAXIFS function - not working

  1. #1
    Registered User
    Join Date
    05-06-2021
    Location
    Seattle, WA
    MS-Off Ver
    Microsoft 365 apps for enterprise
    Posts
    13

    Condition question on MAXIFS function - not working

    Hello,

    I want to determine the max AOV up to a given month number. I'm trying to have a condition with a cell reference using MAXIFS and I keep getting zeros.

    I just got Covid, so maybe my brain is too foggy to get it, but it seems it should be so simple.

    Thanks for any help.

    Michael
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Condition question on MAXIFS function - not working

    You need to put the cell reference outside the quotes, otherwise Excel reads it as just a piece of text. Also, the value is in I6, not J6:

    =MAXIFS('P1 Inputs'!$E$10:$E$34,'P1 Inputs'!$D$10:$D$34,$I$10,'P1 Inputs'!$A$10:$A$34,"<="&I6)

    Hope this helps, and hope you get better soon.

    Pete

  3. #3
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Condition question on MAXIFS function - not working

    Cell I5 formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-06-2021
    Location
    Seattle, WA
    MS-Off Ver
    Microsoft 365 apps for enterprise
    Posts
    13

    Re: Condition question on MAXIFS function - not working

    Thanks Pete! I tried different placements for the quotes, but forgot the ampersand.

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Condition question on MAXIFS function - not working

    Glad to help, and thanks for the rep.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Pete

  6. #6
    Registered User
    Join Date
    05-06-2021
    Location
    Seattle, WA
    MS-Off Ver
    Microsoft 365 apps for enterprise
    Posts
    13

    Re: Condition question on MAXIFS function - not working

    It did solve the original question, and I marked it as solved.

    Thanks again.

+ 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] MAXIFS function not working anymore (currently returns 0)
    By jeriss in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-08-2022, 04:08 PM
  2. MAXIFS criteria1 question
    By John-TS in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-20-2020, 04:35 AM
  3. [SOLVED] MAXIFS and MINIFS not available
    By TFiske in forum Excel General
    Replies: 7
    Last Post: 05-08-2019, 11:27 PM
  4. Maxifs from Sumifs
    By zico8 in forum Excel General
    Replies: 3
    Last Post: 02-22-2019, 04:52 PM
  5. [SOLVED] MaxIFs help
    By Hondahawkrider in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2016, 02:23 PM
  6. MaxIFS help
    By Hondahawkrider in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2016, 03:17 PM
  7. [SOLVED] Having issues writing a 'MAXIFS' array function
    By qaliq in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-23-2013, 11:01 AM

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