Forum Discussion
RMF40
Dec 05, 2024Copper Contributor
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 ...
SergeiBaklan
Dec 09, 2024Diamond Contributor
As variant
=SUMPRODUCT( ($J$3:$Q$6="G") * ($J$1:$Q$1 = "En") * ($J$2:$Q$2 = "E") )
For COUNTIFS() ranges shall be of the same size.