View original (French)

Copy without incrementing any numbers

Solved
plingx Posted messages 144 Status Member -  
plingx Posted messages 144 Status Member -
Hello,

I need to copy a formula across 1000 rows, and there are cell names that should not increment!

My formula is:
=(COUNTIF(F4:DE4,"s")*Accueil!C18)+(COUNTIF(F4:DE4,"b")*Accueil!C17)

I would like to know if it's possible to copy this formula over my thousand rows without incrementing what is in bold!

Thank you!

1 answer

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    =(COUNTIF(F4:DE4,"s")*Home!$C$18)+(COUNTIF(F4:DE4,"b")*Home!$C$17)

    $ placed in front of a fixed row/column this row/column

    Best regards
    4
    1. plingx Posted messages 144 Status Member 20
       
      You're welcome!!
      0