Tag Archives: SUMIF

COUNTIFS and SUMIFS

Yesterday, my friend Alan posed a problem. He wanted to count the number of rows that met criteria in two separate columns. He was frustrated that COUNTIF wouldn't allow him to do that. Since Excel 2007, there have been a … Continue reading

SUMPRODUCTIF

I recently found out how to do the equivalent of a SUMPRODUCTIF, a formula that doesn't exist in Excel. Here’s the detail on how. First of all, some context. SUM does exactly what it says on the tin. It sums … Continue reading