IF formula help
 

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

IF formula help
 

=SUMIF(A:A,"0")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bryan" wrote in message
...
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

IF formula help
 

Try =SUMIF(A1:A100,"0",A1:A100), YOU CAN EXTEND THE RANGE IF NEEDED.

"Bryan" wrote:

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

IF formula help
 

Thanks Bob, that worked a treat!

Bryan

"Bob Phillips" wrote:

=SUMIF(A:A,"0")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bryan" wrote in message
...
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