Forum Discussion
Solved
How do I count the cells in a column where the column header starts with a character?
I have a table where the value in the top row for each column of data starts with either A, H or L. Something like, A_LIT, A__LANG, A_SCI. What I want to do is to count all the cells in each column...
As variant
=SUMPRODUCT( ($A$2:$F$8="x") * (LEFT($A$1:$F$1) = "A") )
=LET(
a,FILTER(A2:F8,LEFT(A1:F1)="A"),
b,TOCOL(a),
c,FILTER(b,b="X"),
d,COUNTA(c),
d)