How do I get a sumif formula or something like it to work for the following scenario
Here is my data in column a and b
1 100
2 50
3 70
4 79
5 85
6 60
7 78
8 90
9 100
I want to add anything greater then 3 and less than 8 by looking at column "a" then adding the numbers in column "B"....the result would be 302 (79+85+60+78)
Help?
Here is my data in column a and b
1 100
2 50
3 70
4 79
5 85
6 60
7 78
8 90
9 100
I want to add anything greater then 3 and less than 8 by looking at column "a" then adding the numbers in column "B"....the result would be 302 (79+85+60+78)
Help?