I have an array which gives the following result
I want to return count of Zero row Wise Like this in an arrray
How to do it ( The range specified above is using Dynamic array formula ) and I want the result to display count in only one range as stated in 2nd sheet
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
AB | AC | AD | AE | AF | AG | AH | |||
4 | |||||||||
5 | 0 | 1 | 1 | 1 | 1 | ||||
6 | 0 | 0 | 1 | 1 | 1 | ||||
7 | 0 | 0 | 0 | 1 | 1 | ||||
8 | 0 | 0 | 0 | 0 | 0 | ||||
9 | 0 | 0 | 0 | 0 | 0 | ||||
10 | 0 | 1 | 1 | 1 | 1 | ||||
11 | |||||||||
12 | |||||||||
13 | |||||||||
14 | |||||||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
AC5:AG10 | AC5 | =--(Z1:Z6>AB1:AF1) |
Dynamic array formulas. |
I want to return count of Zero row Wise Like this in an arrray
Book1 | |||
---|---|---|---|
AJ | |||
5 | 1 | ||
6 | 2 | ||
7 | 3 | ||
8 | 5 | ||
9 | 5 | ||
10 | 1 | ||
Sheet2 |
How to do it ( The range specified above is using Dynamic array formula ) and I want the result to display count in only one range as stated in 2nd sheet