Formula returns error and don't know why

[colinheslop1984]

Hi

The below formula return #VALUE and i'm not sure why

=SUMIFS(INDIRECT("'"&$B$1&"'!$b4:$n17"),INDIRECT("'"&$B$1&"'!$a4:$A17"),$A7,INDIRECT("'"&$B$1&"'!$b2:$n2"),">="&$B2,INDIRECT("'"&$B$1&"'!$b2:$n2"),"<="&$B3)

I have tried the below alternative and get #REF

=SUMPRODUCT((INDIRECT("'"&$B$1&"'!$b4:$n17")*(INDIRECT("'"&$B$1&"'!$a4:$A17"=$A8)*(INDIRECT("'"&$B$1&"'!$b2:$n2">=B2)*(INDIRECT("'"&$B$1&"'!$b2:$n2"<=B3))))))

Any suggestions?

 

[Fluff]

You've got the brackets in the wrong place with the sumproduct. Try
=SUMPRODUCT((INDIRECT("'"&$B$1&"'!$b4:$n17")*(INDIRECT("'"&$B$1&"'!$a4:$A17")=$A7)*(INDIRECT("'"&$B$1&"'!$b2:$n2")>=B2)*(INDIRECT("'"&$B$1&"'!$b2:$n2")<=B3)))

 

[colinheslop1984]

Ah brilliant thanks for your help that has sorted it

 

[Fluff]

You're welcome & thanks for the feedback