What I did wrong

[deciog]

Sirs

In Cell E4 it looks like it counts correctly
In Cell E5 does not count but shows zero
In cell E6 of error

If you drag the cell E6 to cell F4 or another cell of line 4 it shows value 1

I wonder why this happens? Where is the mistake I'm making?

Thank you very much in advance

Decio

 

[bosco_yip]

Hi,

=COUNTIF(INDIRECT("'"&NomesAbas&"'!D4"),Planilha1!C4)

>>

=COUNTIF(INDIRECT("'"&{"Planilha2";"Planilha3";"Planilha4"}&"'!D4"),Planilha1!C4)

>>

=COUNTIF({21;5;20},5)

>>

={0;1;0}

So,

1] If you want to return 0, 1 and 0

In E4, enter :

=COUNTIF(INDIRECT("'"&NomesAbas&"'!D4"),Planilha1!C4)

Then, select/hold E4:E6 altogether >> press SHIFT+CTRL+ENTER >> Finish

2] Or, if you want to return the total sum =0+1+0 =1

In E4, enter :

=SUM(COUNTIF(INDIRECT("'"&NomesAbas&"'!D4"),Planilha1!C4))

Regards
Bosco

 

[deciog]

Bosco

Excellent explanation now, I understand, thank you very much for the help

Hugs

Decio