Thread: Excel formula - help needed!
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
b1888
 
Posts: n/a
Default Excel formula - help needed!
cheers Roger


Roger Govier wrote:

Hi

You need to use 2 Sumif's taking away the values included in the lower
section

=SUMIF(A:A,"<1000",C:C)-SUMIF(A:A,"<500",C:C)


--
Regards

Roger Govier



Reply With QuoteReply With Quote