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.
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:
There are other tips for counting in Excel on my Contextures website.