Results 1 to 4 of 4

max if multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    England
    MS-Off Ver
    MS 365 Enterprise V2210
    Posts
    85

    max if multiple criteria

    hi all,

    I am trying to use Max function but only if it matches multiple criteria (3 criteria)

    I have attached my example to this.

    I want find the max of my criteria A10:C10 from the table above.

    I would like to get the max number in cell D10 (the answer should be 90 in this example)
    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. Replies: 9
    Last Post: 07-23-2015, 01:21 PM
  2. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  3. [SOLVED] countifs statement with multiple criteria for multiple criteria ranges
    By mcdermott2 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2015, 11:48 AM
  4. [SOLVED] UDF for sum of multiple criteria in multiple columns and single criteria in multiple colum
    By Ganesh7299 in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 11-22-2013, 04:26 AM
  5. [SOLVED] create drop down box to select multiple criteria and link macro to each criteria
    By anand_erin in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-03-2012, 06:35 PM
  6. Replies: 2
    Last Post: 10-05-2011, 12:43 PM
  7. MACROS: Sort by multiple criteria - Create tabs based off of criteria
    By svineyard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2009, 10:48 AM

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