I want to add a $ to an already existing $ in a cell in numbers 09. Say I have a cell with $ 20.00 and I want to add an additional $30.00 to the same cell what formula do I use?
Tried a few different ways and couln't find the answer in a tutorial.
Any ideas? thanks
MacBook Pro (15-inch Late 2008), Mac OS X (10.7.3)
In Numbers there is no concept of perform an operation on a cell and put the result in the same cell. You can add a feature like this using Applescript.
Without Applescript you can use a new column to add a fixed value to the values of the adjectne cell... like this:
In column A, I entered the values 1 thru 5. In column I added a formula that adds 10 to the value in column A of the same row:
B1=A1+10
this is shothand for select cell B1, then type (or copy and paste from here) the formula:
=A1+10
select cell B1, then hover the cursor over the bottom edge, then drag the yellow circle down to fill the formula as needed
Hi Wayne
Guess I wasn't clear enough.. In the photography cell I have a sale for $13.85 ... Now I have another sale for $150.00 and I want to add it to the $13.85 for a total of $163.85. Say I have 20 invoices for the month and instead of adding them together outside of numbers, I want to add them in as they come due. There must be a way to add as you go along. Does this explain it any better.
Thanks
Winston
WP,
Your screen grab shows a Summary or Breakout Table. In order to keep that total updated you also need what accountants would call a ledger or log. That would be a separate table listing of all transactions with their dates and categories. From the Ledger the running summary can be calculated.
Jerry
you can sum ALL or a portion of a column (or row) using the function SUM().
In this example the toal of Photography, Framing and Workshops for January appear at the bottom on the column in the footer (row 5).
B5=SUM(B)
this is shorthand for select cell B5, then type (or copy and paste from here) the formula:
=SUM(B)
NOTE... for this formula to work the last row MUST be a footer which you can set up using the table formatter:
for the SUM() function you can simple provide a commas separated list to add up contiguous, or non-contiguous cells...
=sum(A1, B6, G7, H)
would sum cell A1, cell B2, cell G7 and column H
Hi Wayne
I solved my problem..
I had seen it done in Excel for mac, found their formula and tried the same method in numbers. I was putting the $ sign in before and that doesn't work.
I attached a screen shot.
Thanks for your efforts.
WP
HI Wp,
Your formula is going to grow as more invoices come due and you continue to add each individual amount to the equation. One keying mistake, and you are quite likely to delete the entire expression, leaving no record of the original amounts.
A much more reliable method is to use one table (the 'ledger' or 'log' refered to in Jerry's post above) to record the individual amounts and categories as they came due/came in, and a second 'summary' table to calculate the monthly totals shown in the small table in your response to Wayne above.
Separating data entry (in the 'ledger') from category totals makes the data entry easier, and keeps a record of each transaction.
Regrds,
Barry
adding a dollar value to a cell with a dollar value
