I do have Exel on my mac laptop, but I don't use it at all (being used to the mac programs). However, here is a site that I found:


http://www.j-walk.com/ss/excel/usertips/formulatips.htm

And if it doesn't help, I really do hope you find an Excel wiz on here!

Can you describe a bit more what the goal and problem are? Perhaps more description would get answers here where everyone can learn and discuss the best solution(s).

I'm pretty handy with spreadsheets. What are you trying to do?

What are you trying to do?

Well, I have to create a spreadsheet for a company to demonstrate that I know how to use Excel.  They give me all the numbers, I just need to know the formulas to calculate the totals of those numbers.  For instance, this theoretical company owner sells bikes.  He sells them for $250, and he can sell 15 a week.  I have to come up with the formula to calculate the sales for the entire year.  I also have to come up with a formula to calculate the cost of goods for a year - which is $150 per bike.  I can do the math part, that's easy.  It's just the formulas that I'm having a hard time with. 

Can you describe a bit more what the goal and problem are?

See above.  There are very specific formulas that Excel uses to calculate for you so you don't have to do the math yourself.  It's supposed to be easier - I, however, am having a harder time with the formulas than I am the math.  I'm feeling pretty darn stupid, actually, and I'm becoming more and more convinced that Excel is the devil's work - which would make Bill Gates the devil incarnate.

 

And if it doesn't help, I really do hope you find an Excel wiz on here!

I sure hop so too!  Like Terp said, we may all end up learning something from this!

I use Excel at work for an inmate trust fund I have to maintain, but I know just enough to do what I gotta do in there and satisy the auditor and make things balance out. Funny how you can work with something and know know what you're really doing. But of course that's what life is isn't it? Good luck...

Funny how you can work with something and know know what you're really doing.

Hehehe.....like you said, that's life!

If the spreadsheet is set up to show sales by day (giving you 365 rows), you might have the total number sold that day in the first column (A). The next column might have a formula like =A1*250. (You could continue that down that column, increasing the numerical digit appropriately, i.e. A2, A3, etc.) Once you're down at the bottom, you could sum those up, either column. It's up to you whether you want to sum the number of units sold for the year and *then* multiply by 250 to get the total revenue for the year (which keeps it consistent with the rest of your spreadsheet), or you could just sum both columns, first units sold then daily revenue. The summing formula might be something like =SUM(A1:A365).

Is this too basic? Is there a different way that you wanted to deal with it? Do you need to have each month on a separate sheet and then reference each of those onto one other sheet?

Is this too basic?

No, basic is good.  It's an opportunity for me to see how other people do things - I'm always on the lookout for better ways of doing things!

Thanks for the help, Pseudo.

sum=(beginning field:ending field)

or am I missing something?

err, sorry ( too much beer), =sum(beginning field:ending field)