Sumif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
=SUMPRODUCT(--(ABS(C6:T6)>5),--(ABS(C6:T6<50)),ABS(C6:T6))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Hi

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

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