Search tab using indirect for number of times in a range

  • Thread starter Thread starter Pierre
  • Start date Start date
P

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
 
Try it this way:

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

with your sheet name in A1.

Hope this helps.

Pete
 
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 -
Click to expand...
 
Back
Top