excel - Count Column if header is X (formula) -
in sheet 1 have:
(col a) | (col b) 25/aug/2016 | 30/aug/2016 x | | x x | x | x | x | x | x
in sheet 2, want count how many "x" sheet1 column have, based on vlookup date.
i mean, in sheet 2, "if vlookup 30 aug 2016, count how many "x" in corresponding column on sheet 1".
doing bit tricky. sed formula solve problem:
assume table that:
put formula cell n1 , fill down:
=countif(indirect(address(row($a$2),match(a17,$a$1:$j$1,0),4)&":"&address(row($a$13),match(a17,$a$1:$j$1,0),4)),"=x")
and can check my example file well.
Comments
Post a Comment