Excel For Underdogs

Have you ever had trouble trying to count items based on two criteria? Don’t worry – it’s Underdog to the rescue!
Note: There’s a short sound clip in the video, so turn down your speakers if your co-workers are napping.
Underdog Comes to the Rescue in Excel

Use SUMPRODUCT to Count

As Underdog mentioned, you can use the SUMPRODUCT function to count items using multiple criteria. In the video, the formula was:
=SUMPRODUCT(–(B2:B8=”Sun”),–(C2:C8=”Yes”))
Sumproduct
There are other tips for counting in Excel on my Contextures website.
____________