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 General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Computer Help and Support

tiredtoo

(2,949 posts) Tue Jan 31, 2017, 02:02 PM Jan 2017

0

Microsoft excel question

I should know this but it has been awhile since i used excel and my old brain has problems remembering stuff.
formula for sum using a constant cell used to be something like. Sum(*a*1..a20)
this locks in cell a1 if i remember correctly but it will not accept the *
help me i am trying to get an accumulative total here.

4 replies

= new reply since forum marked as read

Highlight:

Microsoft excel question (Original Post) tiredtoo Jan 2017 OP

Its the $ symbol you should use instead of * . Nt. drray23 Jan 2017 #1

Did you remember the equals sign in front? HassleCat Jan 2017 #2

Yep. $. Click on the cell reference in the formula bar and press F4. Or just type it in, like... CurtEastPoint Jan 2017 #3

I thought i already thanked you folks, darn it is hell to get old. Thank you :) tiredtoo Jan 2017 #4

drray23

(7,633 posts)

1. Its the $ symbol you should use instead of * . Nt.

Reply to tiredtoo (Original post)

Tue Jan 31, 2017, 02:05 PM

Jan 2017

HassleCat

(6,409 posts)

2. Did you remember the equals sign in front?

Reply to tiredtoo (Original post)

Tue Jan 31, 2017, 02:08 PM

Jan 2017

CurtEastPoint

(18,650 posts)

3. Yep. $. Click on the cell reference in the formula bar and press F4. Or just type it in, like...

Reply to tiredtoo (Original post)

Tue Jan 31, 2017, 02:15 PM

Jan 2017

$a$4

tiredtoo

(2,949 posts)

4. I thought i already thanked you folks, darn it is hell to get old. Thank you :)

Reply to tiredtoo (Original post)

Tue Jan 31, 2017, 08:28 PM

Jan 2017

Reply to this discussion

Latest Discussions»Help & Search»Computer Help and Support»Microsoft excel question