COUNTIFS with @cell refrence

TPAHDR1

I have a column in one sheet that has data in it such as 0423-01,0423-02,.... the 04 meaning April and the 23 meaning 2023. The -01 or -02 is just the numbering system for that specific month. After April is over there will be more rows added below the 04 ones but now starting with 05 to denote we are now in May.

I am trying to create a formula that references this entire column and counts how many rows there are in the current month that we are in. For example, COUNTIFS([Item]:[Item],VALUE(LEFT(@cells,2))=MONTH(TODAY())).

I feel as though this should work but I am getting the #INVALID VALUE error. The @cells part I think is what is throwing it off but I want the criteria to be based off the range of values but only the first two characters of the cells in that range.

Any help would be greatly appreciated.

Thank you!

Paul Newcome

Try making it just @cell instead of @cells.

TPAHDR1

No I am still getting the same error

Paul Newcome

Can you show the formula actually in the sheet similar to the screenshot below?

TPAHDR1

First screenshot is the formula, second screenshot is showing the {Lee County RRF Punchlist Range 3} is the Item column.

Paul Newcome

I believe I found the issue. Try an IFERROR statement.

COUNTIFS([Item]:[Item],IFERROR(VALUE(LEFT(@cell,2)), 0)=MONTH(TODAY()))