count cells in 1 column and average based on multiple criteria (different columns)

[olga6542]

Good Evening,
1. I need to count fabrics (column A) if value in column B is 1 and cells in column E is not 0.
2. I need to count the average if value in column B is 1 and cells in column E is not 0.

See attached file.

[bebo021999]

Count:
=COUNTIFS($B$2:$B$8,1,$E$2:$E$8,"<>0")
Average:
=AVERAGEIFS($E$2:$E$8,$B$2:$B$8,1,$E$2:$E$8,"<>0")

[wk9128]

Ans 1 =sumproduct((b2:b8=1)*(e2:e8<>0))
ans 2 {=average(if((b2:b8=1)*(e2:e8<>0),e2:e8))}