Search tab using indirect for number of times in a range

[Pierre]

Using
=COUNTIF(INDIRECT(A1!$B$2:$B$112,)"SOLD")
Actually trying to use the tab name (referenced in cell A1), to look
at the range B2:B112 and count the number of times the word "SOLD"
appears. I need to use the indirect function, as there is a long list
of tab names in column A.

The formula is misbehaving. . .Thanks in advance for ideas.
Pierre

 

[Pete_UK]

Try it this way:

=COUNTIF(INDIRECT(A1&"!B2:B112"),"SOLD")

with your sheet name in A1.

Hope this helps.

Pete

 

[Pierre]

Pete:
Works like a charm. Many thanks.
Pierre

Try it this way:

=COUNTIF(INDIRECT(A1&"!B2:B112"),"SOLD")

with your sheet name in A1.

Hope this helps.

Pete




- Show quoted text -

 

[Pete_UK]

You're welcome, Pierre - thanks for feeding back.

Pete