COUNTIF with INDIRECT

[robgrant]

I'm trying to incorporate =COUNTIF(data!B5:B100,"=0")

with INDIRECT (cell ref D3).

I've already tried:

=COUNTIF(INDIRECT"'"&D3&"'(data!B7:B100,"=0"))

Research doesn't seem to turn up anything specific to this case.

 

[barry houdini]

What's in D3?

 

[robgrant]

The word data for the sheet named data

 

[scottylad2]

is the word data text only?

 

[VoG]

Try

=COUNTIF(INDIRECT("'"&D3&"'!B7:B100"),0)

 

[robgrant]

Yes VOG that works like a charm!

Thank you all.

 

[robgrant]

Hey Vog,

Anyway to incorporate INDIRECT into:

=INDEX(data!$A$7:$A$2012,MATCH($A2,data!B$7:B$2012,0))

 

[VoG]

Try

=INDEX(INDIRECT("'"&D3&"'!$A$7:$A$2012"),MATCH($A2,INDIRECT("'"&D3&"'!B$7:B$2012"),0))

 

[robgrant]

Re: INDEX and MATCH with INDIRECT

Vog: You're absolutely amazing!

Works first time, every time.

Thank you again.