hardlythere
New Member
- Joined
- Feb 24, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi All,
Need help on this one. Trying to add wildcard to and Indirect where the Indirect is look up a tab.
=SUMPRODUCT(SUMIFS(INDIRECT("'"&$A10&""*"'!$F:$F"),INDIRECT("'"&$A10&""*"'!$A:$A"),">="&B$3,INDIRECT("'"&$A10&""*"'!$A:$A"),"<="&EOMONTH(B$3,0)))
A10 is that name that I want to wild card i.e. Jo Blogs but tab could be Jo Blogs Jogs
Any suggestions? All information is in the same workbook.
Need help on this one. Trying to add wildcard to and Indirect where the Indirect is look up a tab.
=SUMPRODUCT(SUMIFS(INDIRECT("'"&$A10&""*"'!$F:$F"),INDIRECT("'"&$A10&""*"'!$A:$A"),">="&B$3,INDIRECT("'"&$A10&""*"'!$A:$A"),"<="&EOMONTH(B$3,0)))
A10 is that name that I want to wild card i.e. Jo Blogs but tab could be Jo Blogs Jogs
Any suggestions? All information is in the same workbook.