Formula's

D

Doug

I am trying to create a formula that simple sums a row of
cells and provides a total. The only problem is the fact
that if the sum <= to "0" then the total cell is to be
left blank.

Any ideas?

v/r

Doug
 
R

Rekoj

Doug,

The formula you need would need to have an if statement in
it. For example, if the range that you want to to sum was
A1:A10, then the formula would be as follows:
=if(sum(A1:A10)<=0,"",sum(A1:A10))

Rekoj
 
M

MAC

IF YOUR COLUMN OF FIGURES WAS A1 TO A3, THEN USE THIS
FORMULA =IF(SUM(A1:A3)<=0,"",SUM(A1:A3))

ADJUST A1:A3 TO SUIT YOUR REQUIREMENTS

HTH MAC
 
D

David McRitchie

Please use mixed case, Rekoj's reply is much easier to read because
it was not in uppercase. Posting extensively or large phrases in uppercase is
very hard to read, and it is considered as shouting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top