Forum Discussion
How do I count cells based on column headers and cell value
I have a table where each column has two headers (a header and subheader if you will). I need a formula that will count the number of 'G' values in rows 3 to 6 if the value in the top row ...
=LET(
a,FILTER(A3:H6,(A1:H1&"|"&A2:H2)="En|E"),
b,COUNTA(FILTER(a,a="G")),
c,IFERROR(b,"no match"),
c)