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.
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.
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")
Quang PT
Ans 1 =sumproduct((b2:b8=1)*(e2:e8<>0))
ans 2 {=average(if((b2:b8=1)*(e2:e8<>0),e2:e8))}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks