I am trying to use SUMIFS to sum all the values between 5 and -5, but cannot get it to total these
i have use sum to show the result in E1 and what I am trying to achieve
It would be appreciated if someone could kindly assist me
i have use sum to show the result in E1 and what I am trying to achieve
It would be appreciated if someone could kindly assist me
sumifs between 2 numbers.xlsx | |||||
---|---|---|---|---|---|
C | D | E | |||
1 | 0.01 | 0.00 | -0.02 | ||
2 | -0.01 | ||||
3 | 0.01 | ||||
4 | 825.95 | ||||
5 | -0.01 | ||||
6 | -0.01 | ||||
7 | -0.01 | ||||
8 | -14205.4 | ||||
9 | 0.01 | ||||
10 | 0.01 | ||||
11 | -0.01 | ||||
12 | -0.01 | ||||
13 | -359.46 | ||||
14 | -5470.35 | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1 | D1 | =SUMIFS(C1:C14,C1:C14,"<5",C1:C14,">5") |
E1 | E1 | =SUM(C1:C3,C5:C7,C9:C12) |