Forum Discussion

DTorres_'s avatar
DTorres_
Copper Contributor
Aug 23, 2021

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 put this formula pulling it down or to the side, But it always remains on the B
excel
Excel for web
Excel on Mac
Excel on mobile

4 Replies

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 23, 2021

    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)

    • DTorres_'s avatar
      DTorres_
      Copper Contributor
      Aug 23, 2021
      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!

Resources