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

Counting cells with a certain background?

Updated January 25, 2018 03:03 AM