Forum Discussion
Cont.se
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 pu...
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)
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!
Have you actually tried my suggestion?
- I will try now!