Its best to keep the emails to the list since there are plenty of people that can assist.
The same formula can be used for each of the columns. I've created what I think your after and attached it in .sxc format. /paul On 7/7/05, tim halverson <[EMAIL PROTECTED]> wrote: > Sorry if I am not supposed to write dirrectly to you. I found out what you > were talking about, but my problem still is that I want column A to be the > dates of the month in order down column A. then column B and so on will be > my 12 or so diffrent area's of the store. > > Sory for being a pain > Thankyou > Tim > > > Paul <[EMAIL PROTECTED]> wrote: > > Correct mailing list. In future you also don't have to purchase OOo, > it can be downloaded for free from www.openoffice.org. If you have > brought it, potentially the vendor also has some form of support > available... > > >What I would like to do is put the date in so that at the end of > every month it changes with >the month. > Simply insert the following function, =now(), into a call, then format > the cell as a 'date' and type of "mmm" (which returns only the month). > This will always display the current month. > > >With that have twelve diffrent rows with the amount of money made > that day for diffrent >parts of the store. Hopefully throught he > progam it can add them all up at the end of the >onth and give me a > total. > > If all the values are in a single column (lets say column 'A'), then > simply putting =sum(a1:a12) in the cell A13 will do what your after. > > There are some good tips and advice in the following document about using > calc : > http://documentation.openoffice.org/manuals/oooauthors/Calc_getting_started.pdf > > /paul > > > > Sorry if this is not the correcta area to send this to. > > > > Tim Halverson > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > > > > ________________________________ > Sell on Yahoo! Auctions - No fees. Bid on great items. > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
