Excel Tip: COUNTIFS and SUMIFS

You may be familiar with the original COUNTIF and SUMIF functions, but what about their plural forms? Perfect for calculations when multiple criteria need to be met.