Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combining 2 SUMIF Statements (2.3)

    I have columns of data with the following attributes:

    Column B has key #1, Column F has data to sum, Column G has key #2

    I want to add column f if Col#1 and Col#2 contain two values.

    I can do two sumif statements to do two things at once for a subtraction, but I can not figure out how to do this. What I want is this:

    =(SUMIF(B4:B48,"7.3 fx" & G4:G48, "T",F4:F48)

    This is just adding a second conditional to the sumif function. I know this doe snot work

    Is there a way to do this without a ton of work.

    Thanks,

    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combining 2 SUMIF Statements (2.3)

    What is version 2.3? Do you mean 2003?

    Excel 2007 has a new function SUMIFS that allows you to specify multiple conditions, but SUMIF (available in all versions of Excel) can only handle one condition.

    You can use the SUMPRODUCT function instead:

    =SUMPRODUCT((B4:B48="7.3 fx")*(G3:G48="T")*F4:F48)

  3. #3
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combining 2 SUMIF Statements (2.3)

    Thanks Hans!

Posting Permissions

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