hey all. I'm a beginner just getting the hang of Excell 2008 for Mac and have a question: Is it possible to show math work in a cell and have it work with an autosum that I've set up in another cell? Here's an example...
Let's say I have a business where I take in money over a four day period. I want to create a day by day breakdown of the money I brought in over four cells, with an autosum in another cell giving a grand total for all four days. Pretty simple right? It'd look like this:
(Brackets denote individual cells)
[DAY 1] [$100]
[DAY 2] [$50]
[DAY 3] [$50]
[DAY 4] [$25]
[TOTAL] [$225] <--- AUTOSUM IS HERE
Seems easy enough... except I run into trouble when I try and break it down by transaction within an individual cell. If I try and do that, the autosumed total cell goes screwy on me. Below is how I WANT it to look.
[DAY 1] [$75+$25]
[DAY 2] [$25+$25]
[DAY 3] [$25+$25]
[DAY 4] [$25]
[TOTAL] [$225]
Like I said, if I try and enter it this way, the autosum stops giving me the right answer. Yes, I know I could set up each transaction as a cell. However, understand that I might have varying amounts of transactions perday and I want to keep things orderly (know further that the actual spread sheet I'm making is more complicated than what is above and I have interest to keep it as clean and simple as possible). So, is there any way I can do that or something similar wherein I put more than one numeric value in a cell and still have it work out in the autosum? I also tried listing the transactions with commas instead of plus signs. That didn't work either. Any help would be appreciated!
Bookmarks