Need formula in excel sending sum over 25000 to another column

L

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)
 
F

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT Returning 0 or wrong totals 11
Counting text cells then multiplying by a value in another column 6
Sum values in columns based on values in named range 10
Need formula in excel for filtering large database 2
Sum total using Sumproduct if two criteria met 5
I am using a macro and it cancels my formula 3
function returning SUM of 2 adjacent cols in 2 separate cells 7
Possible getpivotdata with offset? 1

Top