I am using an indirect to pull a value off a tab: INDIRECT($B8&"!$H$268")
$B$8 contains the name of the tab
I want to do the same kind of thing but instead of pulling the value fro $H$268 I want to do a SumIf formula.
=SUMIF($B8&"!C6:C37","10.01"&"*",$B8&"!F6:F37")
In B8 the value is...