Hi, I have created a tracking sheet that contains data and issues brought up each month. Now I am wanting to take data from specific columns and have a formula that counts the entries by month/year in another sheet. I have tried a few different formulas and have been getting errors.
The column I am wanting to calculate has 4 selections, Class 1, Class 2, Class 3 and Class 4. I am wanting to know the total of each at the end of each month/year. I currently have the formula pulling by month but now with a new year i want to separate by year and month.
Here is my current formula, now how do I break it up by year
=COUNTIFS({MMR Quality Alerts 2 Range 1}, ISDATE(@cell), {MMR Quality Alerts 2 Range 1}, MONTH(@cell) = 1, {MMR Quality Alerts 2 Range 2}, "Class 1 Missing Parts")
