Lock Part of a Formula
 

I have two columns (B & C). Column B contains a list of names. Column C
contains a SUMIF formula that checks Sheet '1st By Group'. The SUMIF formula,
when copied & pasted, automatically updates the formula. This is what I
wanted with the CRITERIA; however, I would like to keep the RANGE value from
changing when I copy and paste.

Example:

Row 4 SUMIF Formula: =SUMIF('1st By Group'!B1:B141,"="&B4,'1st By
Group'!C1:C141)
Row 5 SUMIF Formula: =SUMIF('1st By Group'!B2:B142,"="&B5,'1st By
Group'!C2:C142)

I'd like the "="&B5 to change with each paste, but not the references to the
Sheet '1st By Group'.

Hope this makes sense. This is my second post within ten minutes... if I'm
overly confusing or if my formatting isn't what this board prefers, someone
tell me. I teach high school seniors and college freshman; I can take abuse.
Thanks!

Lock Part of a Formula
 

Your question was anticipated and answered in the previous posts.

"SeventFloorProfessor" wrote:

I have two columns (B & C). Column B contains a list of names. Column C
contains a SUMIF formula that checks Sheet '1st By Group'. The SUMIF formula,
when copied & pasted, automatically updates the formula. This is what I
wanted with the CRITERIA; however, I would like to keep the RANGE value from
changing when I copy and paste.

Example:

Row 4 SUMIF Formula: =SUMIF('1st By Group'!B1:B141,"="&B4,'1st By
Group'!C1:C141)
Row 5 SUMIF Formula: =SUMIF('1st By Group'!B2:B142,"="&B5,'1st By
Group'!C2:C142)

I'd like the "="&B5 to change with each paste, but not the references to the
Sheet '1st By Group'.

Hope this makes sense. This is my second post within ten minutes... if I'm
overly confusing or if my formatting isn't what this board prefers, someone
tell me. I teach high school seniors and college freshman; I can take abuse.
Thanks!

Lock Part of a Formula
 

From:
B1:B141
to:
$B$1:$B$141
--
Gary''s Student - gsnu200820


"SeventFloorProfessor" wrote:

I have two columns (B & C). Column B contains a list of names. Column C
contains a SUMIF formula that checks Sheet '1st By Group'. The SUMIF formula,
when copied & pasted, automatically updates the formula. This is what I
wanted with the CRITERIA; however, I would like to keep the RANGE value from
changing when I copy and paste.

Example:

Row 4 SUMIF Formula: =SUMIF('1st By Group'!B1:B141,"="&B4,'1st By
Group'!C1:C141)
Row 5 SUMIF Formula: =SUMIF('1st By Group'!B2:B142,"="&B5,'1st By
Group'!C2:C142)

I'd like the "="&B5 to change with each paste, but not the references to the
Sheet '1st By Group'.

Hope this makes sense. This is my second post within ten minutes... if I'm
overly confusing or if my formatting isn't what this board prefers, someone
tell me. I teach high school seniors and college freshman; I can take abuse.
Thanks!