• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

A question about the SUM formula (I think)

Dave North

New Member
I have written a simple spreadsheet that calculates the quantity of items (Col A)at a given price (Col E) and puts the product of those two columns in Column F. Using the sum formula in Col G =SUM(G3,F4) etc, Col G then shows the running balance as I add additional rows.

Let's say I have 6 rows of entries, and the balance in G6 is $90.00. All the rows in Column G below Row 6, ie, G7, G8 etc show a balance of $90.00. I would prefer them to show a $0 balance.

Then when I add data into Row 7, say 2 items @ $8 each, making F7 $16, G7 would = $106. And G8, G9 etc would be $0 and so on down the sheet.

Is there a formula I can use that will look at column F and if F=$0, will make the sum in G=$0 etc etc down the column, instead of carrying the $90 (or $106, or whatever the latest balance is), all the way down Col G, please?

Some kind of if, then, else formula?

Hope this makes sense.

Thanks in advance for any help.