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 ...
m_tarler
Dec 09, 2024Bronze Contributor
try:
=SUMPRODUCT((A3:H6="G")*(A2:H2="E")*(A1:H1="En"))