COUNTIF within a specific month

kgerholdt

It's now giving me #INCORRECT ARGUMENT SET

Paul Newcome

@kgerholdt Ok. In that case it is most likely an issue with the ranges. Double check that when you are creating your cross sheet references, you are giving the sheet a little bit of time to load in the pop-up window before clicking on the column header.

If you select a range too quickly after the window opens, it may not have completely loaded yet. When it does finally load, the selection automatically reverts back to the "home cell" or top left corner of the sheet. The key to knowing the sheet is fully loaded within the window is that the sheet name should be present in bold immediately under the range name.

kgerholdt

@Paul Newcome I deleted the formula and tried re-entering it after ensuring it was loaded and I still get that same error.

Paul Newcome

@kgerholdt Hmm... Let's try "turning it off and then back on again".

Delete the formula from the sheet. Save it. Sign out. Clear your browser's cookies and cache. Sign back in. Retype the formula from scratch.

What happens now? 🤞

kgerholdt

@Paul Newcome shoot, still the same error. Should I try to use the formula that uses the date range (i.e., looks at first day in month to end of month) and see if that one works?

Paul Newcome

My apologies. It may be an issue with your date range. If it has any blanks or non-date values it could be throwing an error based on the MONT Hand YEAR pieces. Try this in place:

AND(IEFRROR(YEAR(@cell), 0) = 2023, IFERROR(MONTH(@cell), 0) = 1)