View original (French)

Copy without incrementing any numbers

Solved
plingx Posted messages 144 Status Membre -  
plingx Posted messages 144 Status Membre -
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 réponse

Réponse 1 / 1
ccm81 Posted messages 11033 Status Membre 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
plingx Posted messages 144 Status Membre 20
 
You're welcome!!
0