Formula's

  • Thread starter Thread starter Doug
  • Start date Start date
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
 
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
 
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
 
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.
 
Back
Top