Hi

=SUM(ABS(C6:G6)*(ABS(C6:G6)3)*(ABS(C6:G6<=50)))

entered as an array function (Ctrl+Shift+Enter)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"KMH" wrote in message
...
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.