SumProduct/CountIf/Duplicate

I have two questions.

Question #1. In tab 1 is a running sheet of incident report based on office and types of caused that are being recorded daily. In tab 2 is a summary list of all the types of caused for the month. Is there a way that when incidents are being recorded it would transfer and keep count over to the summary sheet by office and types of caused. Should I use the Sumproduct or CountIF in my formula?

Question #2. In tab 3, also another running sheet that keeps track the number of times the customer caused an incident. In tab 4, for any customer that has more than one incident to be transferred over to this sheet by office and account.

TIA,

ExcelNewby

Here is a start.
#1: Both works. Sumif & Countif are simpler to understand than Sumproduct. I just simplified your formula.
#2: It includes a Pivottable. If you have never heard of Pivottables here are some good video tutorial to get you started in no time.

Hope this helped
Ola Sandström

It works great. Thank you for sharing your brain cells!

ExcelNewby