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
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.