OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Formulas in columns

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
dennishelm
Newbie
Newbie


Joined: 13 Mar 2010
Posts: 2

PostPosted: Sat Mar 13, 2010 3:07 am    Post subject: Formulas in columns Reply with quote

I AM HAVING A PROBLEM WITH ENTERING FORMULAS IN COLUMNS.
EXAMPLE: I HAVE A ROW FOR EACH DAY OF THE YEAR 365, I NEED TO ENTER A FORMULA FOR THE 1ST ROW AND THEN CONTINUE DAILY TO THE END OF THE YEAR. WHEN I DRAG THE FORMULA DOWN THE COLUMN I WANT TO KEEP PART OF THE FORMULA THE SAME.
IT ALWAYS CHANGES MY FORMULA 1 DIGIT FOR EACH ROW I DRAG TO.
=SUM(B1+C3) I WANT B1 CHANGE TO B2, B3 ETC AND C3 TO REMAIN THE SAME
SORRY FOR THE LONG QUESTION [
Back to top
View user's profile Send private message
pkon
OOo Enthusiast
OOo Enthusiast


Joined: 26 Feb 2010
Posts: 116

PostPosted: Sat Mar 13, 2010 4:24 am    Post subject: Reply with quote

There's no need for SHOUTING.

Code:
=SUM(B1+$C$3)
Back to top
View user's profile Send private message
dennishelm
Newbie
Newbie


Joined: 13 Mar 2010
Posts: 2

PostPosted: Sat Mar 13, 2010 5:09 am    Post subject: Reply with quote

THANKS, THAT SOLVED MY PROBLEM
Back to top
View user's profile Send private message
pkon
OOo Enthusiast
OOo Enthusiast


Joined: 26 Feb 2010
Posts: 116

PostPosted: Sat Mar 13, 2010 5:16 am    Post subject: Reply with quote

But you're still SHOUTING or maybe your keyboard is out of order!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group