How to get a formula to pull data by month and year.

RebeccaWe

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")

Kimberly Loveless

I am assuming that you have tried....

=COUNTIFS({MMR Quality Alerts 2 Range 1}, ISDATE(@cell), {MMR Quality Alerts 2 Range 1}, MONTH(@cell) = 1, {MMR Quality Alerts 2 Range 1}, YEAR(@cell) = 2023,{MMR Quality Alerts 2 Range 2}, "Class 1 Missing Parts")

Is that correct?

Kimberly Loveless

I am assuming that you have tried....

=COUNTIFS({MMR Quality Alerts 2 Range 1}, ISDATE(@cell), {MMR Quality Alerts 2 Range 1}, MONTH(@cell) = 1, {MMR Quality Alerts 2 Range 1}, YEAR(@cell) = 2023,{MMR Quality Alerts 2 Range 2}, "Class 1 Missing Parts")

Is that correct?