0

I'm trying to count how many times a name appears in different tabs by using indirect to reference the tab name within a countif formula and works fine.

However, as soon as I put it into an ArrayFormula, it stops counting correctly. Does anyone know a way around this (image link below)?

Thanks!

Works =countif(indirect("Semana "&$A2&"!g:g"),$D2)

Doesn't work =ArrayFormula((countif(indirect("Semana "&$A2:A&"!g:g"),$D2:D)))

In columns E and F you can see the different results after making it an ArrayFormula.

Manuel Gongora
  • 1
  • 1

1 Answers1

0

INDIRECT is not supported under ARRAYFORMULA

see: https://stackoverflow.com/a/58314247/5632629

player0
  • 124,011
  • 12
  • 67
  • 124