SUMIF multiple criteria

[mtyrrell13]

I have searched the forum and while I am sure this has been done before, I can not seem to find out what I am doing wrong in this formula. I am trying to sum the totals if criteria "A" = "John" & Criteria "B" = 100% here is the formula I have

=SUM(IF(Cadence!A2:A59,Summary!A1,Cadence!I2:I59,IF(Cadence!R2:R59,Summary!A3,Cadence!I2:I59),0))

 

[Haseeb Avarakkan]

Hello, Try

=SUMPRODUCT(--(Cadence!A2:A59=Summary!A1),--(Cadence!R2:R59=Summary!A3),Cadence!I2:I59)

Or, with Ctrl+Shift+Enter, not just Enter,

=SUM(IF(Cadence!A2:A59=Summary!A1,IF(Cadence!R2:R59=Summary!A3,Cadence!I2:I59)))

 

[T. Valko]

I have searched the forum and while I am sure this has been done before, I can not seem to find out what I am doing wrong in this formula. I am trying to sum the totals if criteria "A" = "John" & Criteria "B" = 100% here is the formula I have

=SUM(IF(Cadence!A2:A59,Summary!A1,Cadence!I2:I59,IF(Cadence!R2:R59,Summary!A3,Cadence!I2:I59),0))

If you're using Excel 2007 or later...

=SUMIFS(Cadence!I2:I59,Cadence!A2:A59,Summary!A1,Cadence!R2:R59,Summary!A3)

This one will work in any version of Excel...

=SUMPRODUCT(--(Cadence!A2:A59=Summary!A1),--(Cadence!R2:R59=Summary!A3),Cadence!I2:I59)