Need formula in excel sending sum over 25000 to another column

[legalcarmen]

I am trying to install a formula in an excel spreadsheet which allows col m
to get filled if sum of col l is over 25000. Only if the sum in col l passes
25000 then col m is filled because if col l is not over 25000 there should be
no value in col m. Please email me at (e-mail address removed)

 

[Fred Smith]

Formulas cannot "send" data to another cell. Formulas always act on the cell
they are in. So in M1, put something like:
=if(sum(L:L)<25000,"",<What you want to appear when over 25000>)

Copy this down column M.

Regards,
Fred

 

[DILipandey]

Hi legalcarmen,

Type following formula in column M and fill it down.

=IF(SUM(L:L)>25000,"Filled","")

--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India