Indirect to pull a value of a tab

[gheyman]

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 1.01.01.01 (which is the name of one of my tabs)
So a normal Sumif that wasn't using an Indirect would be:

SUMIF('1.01.01.01'!C6:C37,"10.01"&"*",'1.01.01.01'!F6:F37)

 

[gheyman]

Got it:

=SUMIF(INDIRECT($B8&"!$C$6:$C$37"),"10.01"&"*",INDIRECT($B8&"!$F$6:$F$37"))

 

[cerfani]

INDIRECT just resolves string to a range... so you need an indirect for each dynamic range referenced...

=[COLOR=#333333]SUMIF([/COLOR][COLOR=#333333]INDIRECT($B8&"[/COLOR][COLOR=#333333]!C6:C37"),"10.01"&"*",[/COLOR][COLOR=#333333]INDIRECT($B8&"[/COLOR][COLOR=#333333]!F6:F37")[/COLOR][COLOR=#333333])[/COLOR]

 

[gheyman]

Thanks!