View Single Post
  #1   Report Post  
Lee
 
Posts: n/a
Default Combining IF and multiple SUMIF statements, if A>0 & B is between

Thanks for the help with my last post.

Im using the following formula to sum column K when the corresponding
number in column BE is between + - 50. AW122 houses -50 and AW123 50.

=SUMIF(BE2:BE118,"="&$AW122,$K2:$K118)-SUMIF(BE2:BE118,""&$AW123,$K2:$K118)

Now Id like to determine the sum for only the positive values in column K.
If the number in column K is greater than 0 and a corresponding number in
column BE is between + - 50, sum the number in column K. The sum in the
example below would be 1

K BE
-0.2 45
1 -43
0.3 54

Thanks for your help.