I’m trying to sum data where the first 8 characters in column “D” equals “PURCHASE” and the amount in Column “B” is less than 0.
The equation below works for tallying all amounts less than 0 in column B.
=SUMIFS(B2:B6, B2:B6, “<0”)
When I try to test both conditions, I get an error.
=SUMIFS( B2:B6, B2:B6, “<0”, (LEFT(D2:D6,8)),”=PURCHASE”)
I’ve also tried various version of SUMPRODUCT
=SUMPRODUCT((LEFT(D2:D506,8)="PURCHASE")*B2:B506)
=SUMPRODUCT( AND( (LEFT($D$2:$D$506,8)="PURCHASE"), ($B$2:$B$506)<0 ) *$B$2:$B$506)
Can anyone help me?
Bookmarks