'display sum conditionally'

--------------------------------------------------------------------------------

i need help inserting a formula that will add a number of cells together with a condition that if the cell above it is empty the cell with the formula will show 0?????????

Perhaps something like

Please Login or Register  to view this content.

entered in A1 ?

mate, you would need to change the title of your thread to something like 'display sum conditionally' or some such.

this is quite easy to setup. since you have not uploaded any sample workbook, here is an indication that you can follow:

in the cell when you want the sum to appear, you can use an IF condition and within that you can insert the SUM function. something like this in A2:

=if(isblank(a1),0,sum(c1:c10))

Nvestaco,

To Attach a File:

1. Click on Go Advanced.
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

have uplaoded the file

as far as i can understand what's going on, the syntax is incorrect.

in cell C33, instead of the "=B33+C31:G31", layout the IF condition as follows:

=IF(C31>1,B33+SUM(C31:G31),0)

mind you, you cannot drag this formula to the right and expect correct results; it is valid only for C33.

i have no financial neuron in my brain, so i haven't the faintest as to what's going on there. put this formula in C33 and see if the result is what you expect it to be. else, revert with input and output values and we will try to get cracking...