Message:

<p>[QUOTE=&quot;Ltrain, post: 980481, member: 24795&quot;]That&#039;s easy.&nbsp; You use the SUM function.&nbsp; So you make your list, then at the bottom, in the last row of cells, you simply put &quot;=SUM(A2:A100)&quot; without the quotation marks... what that would do is add up the total of cells A2 through A100.&nbsp; Do the same for each column, then in the last column, simply put &quot;=(A101+B101+C101)-(D101)&quot; sans quotation marks once again. The first set in brackets (A, B, and C) would be your expenses, and the second (D) would be your estimated value.&nbsp; What remains would be your profit.&nbsp; If you want to add more expenses, just add more columns.</p><p><br /></p><p>Let me show you a picture of what I mean.&nbsp; I changed the formula slightly because this is the way I like it.&nbsp; <img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie7" alt=":p" unselectable="on" unselectable="on" />&nbsp; Sale price minus expenses shows profit.&nbsp; The totals row is just =SUM(B2:B4) in B5, =SUM(C2:C4) in C5, and so on.&nbsp; When you want to add a row for another coin, simply click the number 5 on the side column, then right click it, and hit insert.&nbsp; It should just insert a column.&nbsp; It may say insert column instead, either way it works.&nbsp; If it asks you if you want to shift information, say shift down.[/QUOTE]</p><p><br /></p>

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in