Count of rows created on 2 sheets within a certain time frame.

CSK

Hi everyone!

I would like to get the count of rows created on 2 sheets within a certain time frame.

I created a formula (1) to get the count of one sheet and it worked. I tried to add the other sheet to the formula (2) but I got an error message (3).

1. =COUNTIFS({Created 2}, IFERROR(MONTH(@cell), 0) = 5, {Created 2}, IFERROR(YEAR2cell), 0) = 2024) = 11
2. =COUNTIFS({Created 2}, IFERROR(MONTH(@cell), 0) = 5,{Created 2}, IFERROR(YEAR(@cell), 0) = 2024, {Created}, IFERROR(MONTH(@cell), 0)= 5, {Created}, IFERROR(YEAR(@cell), 0) = 2024)
3. #INCORRECT ARGUMENT SET

Can anyone help?

Paul Newcome

You would use two separate COUNTIFS (one for each sheet) and then add them together.

Paul Newcome

You would use two separate COUNTIFS (one for each sheet) and then add them together.