Thread: Need 'If greater than x, add to cell" formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default Need 'If greater than x, add to cell" formula
=SUMIF(E:E,"0",L:L)

or did you mean

=SUMIF(E:E,"3")


--
Regards,

Peo Sjoblom



"Kathy" wrote in message
...
Hi,
I need help creating a formula. Essentially, if the number in column E is
greater than 3, than I need to add the balance (meaning any number in
excess
of 3) to column L. Any help would be greatly appreciated.
--
Kathy


Reply With QuoteReply With Quote