Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Computer Help and Support

(25,166 posts)

2. Use a "$"

Thu Feb 16, 2023, 08:05 PM

Feb 2023

So:
=SUM(A1+B$1)
=SUM(A2+B$1)
=SUM(A3+B$1)
.....

If you need help, look for info on absolute and relative references.
Hope this helps!

Edit history

Please sign in to view edit histories.

0 members have recommended this reply (displayed in chronological order):

3 replies

= new reply since forum marked as read

Highlight:

Locking cells in formulas [View all] tiredtoo Feb 2023 OP

Use $ QED Feb 2023 #1

Use a "$" lastlib Feb 2023 #2

I was ready to answer, but you have 2 correct responses already. OAITW r.2.0 Feb 2023 #3