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
Bookmarks