sumif and countif using corresponding ranges

[snowman1976]

hello
i am trying to figure out how to do countifs, and sumifs by comparing two ranges.
I am hoping to do this without a 'helper' column, because I have to do this on a bigger scale.

below is my small example. I want to compare the numbers in the quantity column to the target.
1st I need to COUNT the number of times a quantity is equal or greater than the corresponding target.
2nd I need to SUM if the quantity is less than than the corresponding target.

ITEM	Target	Quantity
A	2	3
B	2	1
C	3	1
D	1	2
E	2	2
F	1	1
G	5	4
		4	count number of times quantity >= corresponding target
		6	sum of the quantities less than target (not count)

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C
1	ITEM	Target	Quantity
2	A	2	3
3	B	2	1
4	C	3	1
5	D	1	2
6	E	2	2
7	F	1	1
8	G	5	4
9
10		Count >=	4
11		Sum <	6
Lookup

Cell Formulas
Range	Formula
C10	C10	=SUMPRODUCT(--($C$2:$C$8>=$B$2:$B$8))
C11	C11	=SUMPRODUCT((C2:C8<B2:B8)*(C2:C8))

 

[snowman1976]

both of these worked great, thank you !

 

[Fluff]

You're welcome & thanks for the feedback.