calculate minus figures only
 

Can anyone help me to calculate the minus figures only in a range of random
costs?
example

£-2000.00
£ 1000.00
£ 560.00
£-4500.00

£-6500.00

these figures are random as per data entry to hours and cost etc. the
figures are to show a loss in costs that could have been saved.
i am using excell in office 2000.

any help graciously appreciated.

Thanks,

Nigel

Your question is unclear. Probably you want to do something if the cost is
negative. Suppose these figures are in column A starting at cell A1, then
simply use
=if(A1<0,do_this,else_do_this)
put your required expressions in place of do_this and else_do_this

Mangesh

--
Message posted via http://www.officekb.com

Hi,
I have actually answered my own question but thought i'd let you all know.
formula is:

=sumif(range,"<0")

Thanks anyway,

Nigel

"Nigel" wrote:

Can anyone help me to calculate the minus figures only in a range of random
costs?
example

£-2000.00
£ 1000.00
£ 560.00
£-4500.00

£-6500.00

these figures are random as per data entry to hours and cost etc. the
figures are to show a loss in costs that could have been saved.
i am using excell in office 2000.

any help graciously appreciated.

Thanks,

Nigel