Summarizing and reporting data from several sheet columns
Hey all, I'm having trouble figuring out how to summarize data for a specific time period, for a specific customers. I have a date column, a customer plant column and total defects column. My Liaisons add data to the sheet when defects are found at the customer plant for which they cover. So I have several line items for each customer spanning months.
I want to sum the total number of defects for each customer for a specific time period, say each month. I am having trouble trying to figure out how to do this.
Here's an example of what my sheet looks like
Help Article Resources
Check out the Formula Handbook template!