Using @SUM only when a cell is greater then zero

[Danno]

I have a spreadsheet that has a cell entry for every week in a year (52). Each week I want to put in the value for that week, and have Excel add the column only to the point where there's a value entered, that's greater then zero. When I used to use Lotus, I thought the formula looked like "IF+C10 > 0, then @SUM +c3.+c10". Any help would be appreciated
Thanx

 

[John1215]

Hi,

I think I understand the problem lets see. Assume that your total is i
A11 and your are totalling the figures in A1 to A10. You only want t
input a total if the sum of these cells is greater than zero??

Then this formula will do that:-
=IF(SUM(A1:A10)>0,SUM(A1:A10),""

 

[Peo Sjoblom]

Or simpler

=SUMIF(A1:A10,">0")

 

[Danno]

Thanks John...only I wasn't very clear

I have one column that I enter weekly numbers in (i.e. column "E", rows 1 thru 52). In another column (i.e. "H") I want to produce a total 'Year to Date'. When I set it up by simply using the @SUM function, I get the total 'Year to Date' figure from the week I'm working with (i.e. Week 11), all the way from Week 11 through Week 52. I'd like to have the worksheet only total from Week 1, down to the week I'm working with. I'd like to have all the weeks below the one I'm working with, show 'Zero'. I hope that's a little clearer.

 

[RagDyer]

See the answer I posted to your <Should I be using "IF"> thread.

Please stick with the same thread until it gets resolved to your
satisfaction.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Thanks John...only I wasn't very clear.

I have one column that I enter weekly numbers in (i.e. column "E", rows 1
thru 52). In another column (i.e. "H") I want to produce a total 'Year to
Date'. When I set it up by simply using the @SUM function, I get the total
'Year to Date' figure from the week I'm working with (i.e. Week 11), all the
way from Week 11 through Week 52. I'd like to have the worksheet only total
from Week 1, down to the week I'm working with. I'd like to have all the
weeks below the one I'm working with, show 'Zero'. I hope that's a little
clearer.