jeffreysdunn
New Member
- Joined
- Nov 13, 2011
- Messages
- 35
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.
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.