Thread: need help with SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kerri Olsen Kerri Olsen is offline
external usenet poster
  
Posts: 11
Default need help with SUMIF
I need help writing a formula

if range E18:E23 is greater than 40, I want the number E18:E23-40 entered
into the cell, if false 0
--
Kerri
Reply With QuoteReply With Quote