SUMPRODUCT +SUMIFS + INDIRECT then add a wild card

[hardlythere]

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.

 

[Fluff]

Hi & welcome to MrExcel.
You cannot use wildcards like that, indirect needs the full sheet name.