The data shows the cost and the quantity sold of several items. I need a formula that would count the number of items sold within a range of prices. Right now I have the formula:
=SUMIF(A3:A11,">10.00",B3:B11)
The answer = 24, which is correct.
The criteria (>10.00) sums the items that are greater than $10.00. I need it to count items that are >10.00 AND <22.00. The "AND" is the problem, I don't know how to incorporate it into the criteria. I was thinking an IF, but got stuck.
Thank you very much in advance.
Cost QTY
10.00 2
10.00 3
10.00 25
15.00 10
15.00 2
15.00 2
20.00 2
20.00 3
22.00 5
2007-01-23
08:55:56
·
3 answers
·
asked by
ledezmajr
3