Link to home
Create AccountLog in
Avatar of Kevin Smith
Kevin SmithFlag for United States of America

asked on

How do I copy formula to the next column and have it auto change one parameter?

I have the following formula:

=SUMIF(C11:C10000,"Engineering",E11:E10000)

...I can copy it to the next column and it of course changes the C and E to D and F, but I really only want it to change the second set of numbers and leave the C as is.

How do I do this?
ASKER CERTIFIED SOLUTION
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Kevin Smith

ASKER

Perfect, thanks!
For info - the $ fixes the parameter which it prefixes eg

$A1 - fixes just the column reference
A$1 - fixes just the row reference
$A$1 - fixes both row and column

Tip: Put the cursor on the cell reference in the formula bar and press [F4] to cycle through the options.