robertdseals
Active Member
- Joined
- May 14, 2008
- Messages
- 334
- Office Version
- 2010
- Platform
- Windows
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))
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))