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") )
As variant
=SUMPRODUCT( ($A$2:$F$8="x") * (LEFT($A$1:$F$1) = "A") )