Thread: sum within a range of numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default sum within a range of numbers
=SUMIF(A:A,"=50001")-SUMIF(A:A,"200000")

Vaya con Dios,
Chuck, CABGx3


"Luis" wrote in message
...
I have a long list of numbers that ranges from 680,608.60 to 131.06.
I need to sum only those within 50,001 and 200,000.


Reply With QuoteReply With Quote