Using worksheet name in formula

[jeffreysdunn]

I have identically formatted worksheets named Q12022, Q2022 etc. On a summary sheet I have column headers with the same names. How do I reference the correct worksheet in a sumif formula on the summary sheet?

my formula is:

=sumif('Q32022'!J:J,C4,'Q32022'!H:H)*D4

I want to substitute the content of a cell (k2 for instance) for the worksheet name Q32022.

Many thanks.

 

[Fluff]

How about

=SUMIF(INDIRECT("'"&K2&"'!J:J"),C4,INDIRECT("'"&K2&"'!H:H"))*D4

 

[jeffreysdunn]

Works nicely. I'm not sure I understand what the indirect function is doing but I'll research that.

Thanks again.

 

[Fluff]

Glad to help & thanks for the feedback.