software

Hi,

I have created a budget re-forecasting spreadsheet to circulate around my
team. One of the colums shows the variation from the original budget for
each project which is either positive or negative. Is there a formula that
could total only the positive figures e.g. IF cells within the colum are
positive count them but if not dont?

Thanks in advance,
Bryan

=SUMIF(A:A,quot;gt;0quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Bryanquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have created a budget re-forecasting spreadsheet to circulate around my
gt; team. One of the colums shows the variation from the original budget for
gt; each project which is either positive or negative. Is there a formula
that
gt; could total only the positive figures e.g. IF cells within the colum are
gt; positive count them but if not dont?
gt;
gt; Thanks in advance,
gt; Bryan
Try =SUMIF(A1:A100,quot;gt;0quot;,A1:A100), YOU CAN EXTEND THE RANGE IF NEEDED.

quot;Bryanquot; wrote:

gt; Hi,
gt;
gt; I have created a budget re-forecasting spreadsheet to circulate around my
gt; team. One of the colums shows the variation from the original budget for
gt; each project which is either positive or negative. Is there a formula that
gt; could total only the positive figures e.g. IF cells within the colum are
gt; positive count them but if not dont?
gt;
gt; Thanks in advance,
gt; Bryan

Thanks Bob, that worked a treat!

Bryan

quot;Bob Phillipsquot; wrote:

gt; =SUMIF(A:A,quot;gt;0quot;)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Bryanquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; I have created a budget re-forecasting spreadsheet to circulate around my
gt; gt; team. One of the colums shows the variation from the original budget for
gt; gt; each project which is either positive or negative. Is there a formula
gt; that
gt; gt; could total only the positive figures e.g. IF cells within the colum are
gt; gt; positive count them but if not dont?
gt; gt;
gt; gt; Thanks in advance,
gt; gt; Bryan
gt;
gt;
gt;