October 19th, 2021
excel

Microsoft Excel – 45: Array Formulas – Sum

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

Microsoft Excel – 44: Array Formulas – Count

Microsoft Excel – 06: AVARAGE, MIN and MAX

Leave a comment

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