COUNTIFS versus SUMPRODUCT

Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.

Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.