Indirect

[Holger]

Hi guys,

any help would be greatly appreciated:

This works: =COUNTIFS(HeadcountFeed!$G$4:$G$600,">="&$B$8,HeadcountFeed!$G$4:$G$600,"<="&$B$9,HeadcountFeed!$F$4:$F$600,$A45)
This does not: =COUNTIFS(INDIRECT(B15,TRUE),">="&$B$8,INDIRECT(B15,TRUE),"<="&$B$9,INDIRECT(B15,TRUE),$A45) with B15 being: 'HeadcountFeed'!$G$4:$G$600

Any help would be awesome.

Cheers

 

[Dim Me as xlNoob]

Either remove the apostrophies from B15 or add an extra one at the start. Both ways work at my end.

B15=

''HeadcountFeed'!$G$4:$G$600 <-- That's two apostrophies, not a quotation mark.
or
HeadcountFeed!$G$4:$G$600

Also in your first formula the range is HeadcountFeed!$F$4:$F$600, is it meant to be F? Because in the second formula it is G.

 

[Holger]

Either remove the apostrophies from B15 or add an extra one at the start. Both ways work at my end.

B15=

''HeadcountFeed'!$G$4:$G$600 <-- That's two apostrophies, not a quotation mark.
or
HeadcountFeed!$G$4:$G$600

Also in your first formula the range is HeadcountFeed!$F$4:$F$600, is it meant to be F? Because in the second formula it is G.

Awesome and thank you so much!!! Re F referecne, that is correct as it relates to something else in my data. Thanks again mate!