| View previous topic :: View next topic |
| Author |
Message |
dennishelm
Newbie
Joined: 13 Mar 2010
Posts: 2
|
 Posted: Sat Mar 13, 2010 3:07 am Post subject: Formulas in columns |
 |
|
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 |
|
 |
pkon
OOo Enthusiast
Joined: 26 Feb 2010
Posts: 116
|
| Posted: Sat Mar 13, 2010 4:24 am Post subject: |
|
|
There's no need for SHOUTING.
|
|
| Back to top |
|
|
dennishelm
Newbie
Joined: 13 Mar 2010
Posts: 2
|
| Posted: Sat Mar 13, 2010 5:09 am Post subject: |
|
|
| THANKS, THAT SOLVED MY PROBLEM |
|
| Back to top |
|
|
pkon
OOo Enthusiast
Joined: 26 Feb 2010
Posts: 116
|
| Posted: Sat Mar 13, 2010 5:16 am Post subject: |
|
|
| But you're still SHOUTING or maybe your keyboard is out of order! |
|
| Back to top |
|
|
|
