SUM of a row.

[DugiDug]

Hey.

How can u make a SUM function, that will only sum the cells, if the cells have any numbers in them?

[Fotis1991]

Take a look to SUMIF function.

[dilipandey]

Are you talking about how to extend the range reference in Sum Function. If so, try looking at Defined names.

If stuck, upload a sample workbook.. thanks.


Regards,
DILIPandey
<click on below * if this helps>

[DugiDug]

I thought of that, but what should I put as criteria?

And sry for duplicate post before, just thought that the old one would disapear.

[Fotis1991]

If stuck, upload a sample workbook.. thanks.


Regards,
DILIPandey
<click on below * if this helps>

.............................

[DugiDug]

Here is a sample:

Sample of SUM.IF.xlsx

[Fotis1991]

In D6 and copy down. ??????

=IF(C6<>"",SUM($C$5:C6),"")

[DugiDug]

Weird, it works on the sample, but not at my spreadsheet. :s

[Fotis1991]

Your real workbook is different from your sample...

[DugiDug]

Yes. It has a formular in the "C" colum.

[Lemice]

I'm pretty sure SUM(something:something) will ignore blank / cell with text, so it will return the sum of all numbers can be found in a range? (Unless in that range there are errors)

[Fotis1991]

Makes no sense for me to attach a different example of your real data.

If you like upload a sample exactly as your real data, or else we'll do 30 posts without result..