Sum base on several conditions

**kepasso** · 01-08-2015, 04:45 PM

Hello

I need to sum data base on three conditions:
1. account nr.
2. date
3. "credit" or "debit"

This formula doesn't works: =SUM(($A$2:$A$22=$G$4)*($B$2:$B$22=$G$2)*($D$2:$D$22=G6))

I attached file.

Thankssum.xlsx

**JieJenn** · 01-08-2015, 04:51 PM

In G7 enter =SUMPRODUCT(--($A$2:$A$22=G4),--($B$2:$B$22=G2),--($D$2:$D$22=G6)) and drag to left under Credit

**protonLeah** · 01-08-2015, 04:59 PM

F7:

Please Login or Register  to view this content.

g7:

Please Login or Register  to view this content.

**kepasso** · 01-08-2015, 05:04 PM

Hi, it shows me only counted - Credit.. I need to sum data.

**kepasso** · 01-08-2015, 05:06 PM

Thanks, it works

**JieJenn** · 01-08-2015, 05:07 PM

Oh yeah, my bad. F7 =SUMPRODUCT(--($A$2:$A$22=F4),--($B$2:$B$22=F2),--($D$2:$D$22=F6),$C$2:$C$22) then drag to the right.

I can't remember if 2007 support SUMIFS. If it does, protonLeah's forumla works better.