If the criteria is between two numbers, sum a different column

[robertdseals]

Hello,
This should be easy, but I can't figure it out. In column A I have number 1000, 2000, 3000...etc. In column B I have amounts. I want to write a "sumif" that says something along the lines of "sum the numbers in column B IF the value in column A is between 2000 and 2999. Simple...but I can't seem to figure it out!
This didn't work. =AND(SUMIF(SoftIncr.!A:L,">6999",SoftIncr.!B:B),SUMIF(SoftIncr.!A:L,"<8000",SoftIncr.!B:B))

 

[jtakw]

Hi,

Try it this way:

Book3.xlsx
	A	B	C	D
1	1000	10		170
2	2000	20
3	3000	30
4	2100	40
5	2999	50
6	2001	60
7	3001	70
Sheet1044

Cell Formulas
Range	Formula
D1	D1	=SUMIFS(B1:B10,A1:A10,">=2000",A1:A10,"<=2999")

 

[robertdseals]

DANG! I knew it would be simple! Thanks for the help.

 

[jtakw]

You're welcome, thanks for the feedback.