Results 1 to 2 of 2
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    New York, New York, USA
    Thanked 0 Times in 0 Posts

    Sumif with multiple criteria (XP)

    Hi - I have a column of numbers that I want to add up but only if the associated date is greater than a selected date AND a 'Y' appears in another column. I have a sumif function set up to sum the numbers if the date is greater than a selected date and I was trying to add the second criteria. Does sumif work like this or do I have to use some other function - or create a unique column that returns TRUE based on both tests?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Sumif with multiple criteria (XP)

    SUMIF in combination with a column with TRUE/FALSE values that combine the conditions is one way.
    You can also use SUM or SUMPRODUCT. For example, let's say that the dates are in A1:A100, the "Y"s in B1:B100 and the numbers to be added in C1:C100. The comparison date is in F1.


    or as an array formula (confirm with Ctrl+Shift+Enter):


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts