Hi

You could use SUMIF:

=SUMIF(C6:T6,"=5.01")-SUMIF(C6:T6,"50")

or maybe SUMPRODUCT:

=SUMPRODUCT(--(C6:T6=5.01),--(C6:T6<=50),C6:T6)

Hope this helps!

Richard



KMH wrote:

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.