Thread: How do I enter formula that adds a range if less than a number or
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rose M
 
Posts: n/a
Default How do I enter formula that adds a range if less than a number or
I want to write formula that adds amounts in a range ofcells and if < a
number, enter sum, but if = than number, only add difference between sum and
number? I believe it to be an sumif function but can't seem to layout
formula.
Reply With QuoteReply With Quote