Sumifs between 5 and - 5

[howard]

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

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)

 

[Toadstool]

Hi Howard,

Aren't you just missing the minus sign?

Howard4.xlsx
	C	D
1	0.01	-0.02
2	-0.01
3	0.01
4	825.95
5	-0.01
6	-0.01
7	-0.01
8	-14205.36
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")

 

[howard]

Thanks Toadstool. I overlooked the minus sign