Thread: Sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KMH KMH is offline
external usenet poster
 
Posts: 31
Default Sumif

Hello, I have a sheet with totals both positive and negetive on it from say
c6 to t6, I need w6 to sum the totals that are between 5.01 and 50 both
positive and negetive, and give me the sum in a positive number so the
negetive don't cancel out the positives. ie the number 3 6 25 -3 and -14
appear, I need W6 to show 44 (6+25+14)
--
Thanks for your help, advice, ideas, and time.