INDIRECT or alternative

[Luke777]

Hi,

I can’t quite figure out how to do this despite numbers attempts.

I’m creating a formula on a sheet. This formula refers to another sheet. The sheet it refers to is selected by the user.

B1 contains the month
B2 contains the year

The sheet (for simplicity) being referenced will be August 2023.

I’m struggling to get indirect to look at B1 AND B2 before the “!” WITH a space (“ “) between B1 and B2.

The formula without the indirect is just =COUNTIF(N:N,”Validated”).

I’m building a simplistic report page where the count of “Validated” can be user selected by month-year

Thanks all

 

[Fluff]

How about

=COUNTIF(indirect("'"&b1&" "&b2&"'!N:N"),"Validated")