Cont.se

[DTorres_]

Hi! I want to know how I can make this formula formula: =cont.se('Artifício de contagem'! B$5:B$1000;$H$4)
Change only the B5 and B1000. For C5 and C1000, After D5 and D1000, and so on.
I want to put this formula pulling it down or to the side, But it always remains on the B

[#2]

@DTorres_ 

If you want to fill to the right, it should work as it is now.

If you want to fill down, let's say the first formula is in D3.

Change it to

=CONT.SE(ÍNDICE('Artifício de contagem'!$5:$1000;0;LIN(D3)-LIN($D$3)+2);$H$4)

[#3]

No, like. I want the formula to remain the same, but just B5 and B1000 to change C5 and C1000, so on successively. This for columns!

[#4]

@DTorres_ 

Have you actually tried my suggestion?

[#5]

I will try now!