View Full Version : spreadsheet question
03-30-2005, 07:42 PM
i have taught myself how to make spreadsheets to keep track of my scores and averages on every hole for several discgolf courses. basically just entering simply multiplication or division formulas in box to keep averages. lame, i know :rolleyes: here is an example: =C2/B2 to get average on a certain hole, or to figure my average round on the course: =d29*(18)-54
now i am trying to do something simple. have a running total of something added together. seems easy, but i can't get it. i've tried =C2+D2, and other variations.
i am using staroffice. very similar to microshaft, and will open their spreedsheets. any help will be appreciated :cool:
03-30-2005, 08:28 PM
Not sure if I'm understanding you correctly, but see if this helps.
that will total a specified range of cells.
03-30-2005, 08:45 PM
that didn't work shake. basically there are several items that i want to keep a running tally of. it would update the count using addition formula in a seperate cell. i'm baffled :confused:
03-31-2005, 08:53 AM
If your software has similar functions to MS Excel, which you stated that it is somewhat similar, then Shake's formula should work to sum a range of rows or columns. If you were doing numbers down a column you would use
which would summarize the values in cells in column "C" and rows 2 through 5. For more rows to be included the number can change.
I hope this helps.
03-31-2005, 10:40 AM
=SUM(D5:G5) should work, did you include the brackets? I use this formula to track my expenses for tournaments, gas +motel+entry fees gives me a total.
03-31-2005, 06:05 PM
i am trying to attach my first pic on a post, so wish me luck.
i want to keep a running tally of several stats for every team in the league. example: if foul territory scores 1 run last week; i want to enter 1 in C2, and have foul territory's season run total be updated in C14
most categories will be simple addition. there will be some averages averaged together too.
thanks for the help, disc
03-31-2005, 08:01 PM
i think you need an initial value within c15 at the start of your spreedsheet, cuz the way it looks now your adding c3 + nothing = Err. (i could be wrong here :p )
i have a excel sheet at work with some functions similar to what you need to do. it keeps running tallys month by month of how many pieces of film were cut for any givin month. all i do is enter the value in a cell and it adds all previous values together in same row. if the date has not been passed, it passes the same value down the whole row to dates that have not occured yet. (okay, that really isnt a good explaination but....) anyway i'll email it to you tomorrow so you can see the functions..... ;)
03-31-2005, 09:52 PM
04-04-2005, 09:04 AM
It looks to me like you have what is called a circular reference in your calculation. The cell C15 has a formula that says to add cell C3 and C15. The problem with this is that once you add the two the value in C15 changes thus changing the answer. It becomes like a cat chasing his tail. I hope that make sense. In other words you do not want to create a formula that references the cell that the formula is in or you will always get this problem. If you are wanting the total of C3 and C15 then use the formula that you have but put it in another cell in the worksheet.
04-04-2005, 09:31 AM
i have taught myself how to make spreadsheets to keep track of my scores and averages on every hole for several discgolf courses. basically just entering simply multiplication or division formulas in box to keep averages. lame, i know here is an example: =C2/B2 to get average on a certain hole, or to figure my average round on the course: =d29*(18)-54
Discgolfer, sure sounds like you have one very exciting life. So whats your current handicap (score average)?
After my latest escapades, I might have to take up disc golf as I won't be able to afford real golf.
04-04-2005, 09:37 AM
Rt. click on the picture, then copy & paste that http addy in the post. Click on the Insert Image icon and paste it in that window. :)
More info on how to (click) here. (http://www.ohiogamefishing.com/forums/showthread.php?t=23973)
04-04-2005, 05:40 PM
thanks guys. here's a shot of the new one. i had to list out every week to get the desired effect. i'm sure there was an easier way though.
welcome back sheephead. i am my biggest handicap :D:D just depends on the course i guess. i really havent thrown much in last 2 years, but am going to take it up again soon if liq. tension doesnt get his boat out of storage:D:D:D
04-04-2005, 05:43 PM
04-04-2005, 05:46 PM
just getting used to posting a pic now
04-04-2005, 09:05 PM
i really havent thrown much in last 2 years, but am going to take it up again soon if liq. tension doesnt get his boat out of storage
its coming home this week....
man, the snow just turned me off... along with losing an hour.... didnt even get outta bed till noon sunday :rolleyes: :p
vBulletin® v3.8.7, Copyright ©2000-2013, vBulletin Solutions, Inc.