Tag Archives: SumIf

Excel – Using absolute cell references in SUMIF, COUNTIF, SUMIFS, COUNTIFS, etc

When you are using a function such as COUNTIF, the syntax is =COUNTIF(Criteria_range, criteria). In general the criteria needs to be enclosed in double quotes. What happens if you want to reference a cell as part of your criteria? Say, … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment