December 5th, 2021
excel

Microsoft Excel – 44: Array Formulas – Count

How to Count records using multiple criteria to select only certain criteria.
=SUM(($A$2:$A$14=F$2)*($B$2:$B$14=$E3))

Microsoft Excel – 43: Array Formulas

Microsoft Excel – 45: Array Formulas – Sum

Leave a comment

Your email address will not be published. Required fields are marked *