Quick formula hacks with SUMIF and COUNTIF

Get more flexibility and speed from SUMIF and COUNTIF functions, whether you are new to them or use them already.

Want to sum only the positives or negatives from a combined list of numbers? Need to add or count items based on matching an account number, date, or description?

Here’s a quick way to do all this and more.

ExcelQuicker.com Tip of the week: Quick formula hacks with SUMIF and COUNTIF
ExcelQuicker.com Tip of the week: Quick formula hacks with SUMIF and COUNTIF

Tip of the week from ExcelQuicker.com

Get a new tip each week for free at ExcelQuicker.com

Finish spreadsheets faster. It’s your time!

--

--