calculate minus figures only

N

Nigel

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
 
M

Mangesh Yadav via OfficeKB.com

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
 
N

Nigel

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

=sumif(range,"<0")

Thanks anyway,

Nigel
 
Top