Excel Magic Trick 1156

Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)

DESCRIPTION

See how to Count the “N” (New) and “U” (Used) for Each Sale
(00:08) Problem Setup
(01:08) Two COUNTIFS functions with Mixed Cell References (Longer formula but faster calculating)
(03:47) SUMPRODUCT with Boolean Multiplying on Two Different Sized Ranges with Mixed Cell References (Shorter formula but slower calculating)




Be the first to comment

Leave a Reply