COUNTIF and SUMIF formula with multiple criteria

[excelnewb221]

Hello,

Would really appreciate some help on this, i've been struggling with it all day.
I've mostly tried variations of index/match, countifs, sumifs, but it i'm having trouble factoring in the different criteria, so i'm basically lost.
I'm basically looking to create two formulae. one that gives a count of negative and positive numbers based on criteria, and a second formula that gives a sum of those negative and positive numbers, based on the same criteria.
please let me know if i can explain or elaborate on the below better.
thank you for the help




Sheet1:

Book1
	A	B	C
1	Fruit	Status	Formula
2	Orange	Fresh	if A2 of Sheet1 is in column A of Sheet2, and column B of Sheet1 equals column C of Sheet2, then give a count all values not equal to 0 in column B of Sheet2
3	Apple	Fresh	if A3 of Sheet1 is in column A of Sheet2, and column B of Sheet1 equals column C of Sheet2, then give a count all values not equal to 0 in column B of Sheet2
4	Banana	Stale	if A4 of Sheet1 is in column A of Sheet2, and column B of Sheet1 equals column C of Sheet2, then give a count all values not equal to 0 in column B of Sheet2
5	Strawberry	Stale	if A5 of Sheet1 is in column A of Sheet2, and column B of Sheet1 equals column C of Sheet2, then give a count all values not equal to 0 in column B of Sheet2
6	Blackberry	Fresh	if A6 of Sheet1 is in column A of Sheet2, and column B of Sheet1 equals column C of Sheet2, then give a count all values not equal to 0 in column B of Sheet2
7
8
9			if A2 of Sheet1 is in column A of Sheet2, and column B of Sheet1 equals column C of Sheet2, then give the sum of all values not equal to 0 in column B of Sheet2
Sheet1

Sheet2:

Book1
	A	B	C
1	Fruit	Price	Status
2	Strawberry	-4	Old
3	Blackberry	5	Fresh
4	Banana	0	Fresh
5	Orange	2	Old
6	Apple	-8	Fresh
Sheet2

 

[Cubist]

How about

Book1
	A	B	C	D
1	Fruit	Status	Count	Sum
2	Orange	Fresh	0	0
3	Apple	Fresh	1	-8
4	Banana	Stale	0	0
5	Strawberry	Stale	0	0
6	Blackberry	Fresh	1	5
Sheet1

Cell Formulas
Range	Formula
C2:C6	C2	=COUNTIFS(Sheet2!$B$2:$B$6,"<>0",Sheet2!$A$2:$A$6,Sheet1!A2,Sheet2!$C$2:$C$6,Sheet1!B2)
D2:D6	D2	=SUMIFS(Sheet2!$B$2:$B$6,Sheet2!$B$2:$B$6,"<>0",Sheet2!$A$2:$A$6,Sheet1!A2,Sheet2!$C$2:$C$6,Sheet1!B2)

 

[excelnewb221]

Perfect, thanks so much!