0

I'm using Google sheets for storing some simple text. In a column (F) I have all names of sheets and I'm using the following to count occurrences of a certain string "aaa" in column C in all sheets:

SUMPRODUCT(COUNTIF(INDIRECT("'"&F3:F11&"'!C3:C200"),"*aaa*"))

It returns only occurrences in the first sheet. Any idea what is wrong?

BigBen
  • 46,229
  • 7
  • 24
  • 40
Drimades Boy
  • 437
  • 1
  • 5
  • 19
  • share a copy of your sheet with example of desired output – player0 Jul 07 '20 at 21:09
  • 1
    Does this answer your question? [Using ARRAYFORMULA and INDIRECT to iterate rows and return as a block](https://stackoverflow.com/questions/20625539/using-arrayformula-and-indirect-to-iterate-rows-and-return-as-a-block) – Rubén Jul 08 '20 at 02:56

0 Answers0