LinkBack URL
About LinkBacks
Hi all,
Untitled.png
Is there a formula that would allow me to drag across the entire row? Thank you in advance for any help or ideas.
Hi all,
Untitled.png
Is there a formula that would allow me to drag across the entire row? Thank you in advance for any help or ideas.
USing the + symbol is reduntant in SUM() functions. What you want to use is a range reference, where the A column is "absolute" and the other column is relative. Something like:
=SUM($A1:A1). Note the $ in front of the first A.
See this for a discussion on using relative, absolute, and mixed references in formulas: https://support.office.com/en-us/art...es_in_formulas
Originally Posted by shg
Yep, I understand that. Thank you for your prompt response MrShorty (:
I tried your method, and it worked too. Much more elegant and simple. Thank you so much!
I figured out offset would work here:
=SUM(OFFSET($A$1,0,0,1,COLUMN()))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks