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)