This seems like it would be a simple formula but I keep getting a #Value error when I try it. Trying to get a count based on criteria in Column A in addition to Row 1:
DATA:
<tbody>
LOCATION
P01_2018
P02_2018
P03_2018
P04_2018
P05_2016
NO
1
1
1
1
1
USATL
0
0
0
1
0
NO
0
0
0
0
0
NO
1
0...