OK, now that we are getting through the SUMIFS nightmare, there are two things to know: SUMIFS are good when they work and COUNTIFS give you some debugging. The main problem is that there isn’t any way to figure out what rows are actually summed up, so no way to know about doubling counting. For […]