Sumifs summing when conditions evaluate false?

by user1543042   Last Updated May 15, 2018 18:03 PM

I have a sheet with five columns: ID1, ID2, date, quantity, and the cumulative sum that match both ID1 and ID2. The last is a sumifs shown below

enter image description here

And even though the ID1 (4) and ID2 (2) first occur in row 4 it is summing to 1. What is going on?

The Google sheet is here.

Related Questions

Excel function: IF, AND, ISDATE, THEN

Updated August 15, 2018 05:03 AM

Concatenate in side an arrayformula with google sheets

Updated January 10, 2018 23:03 PM