=SUM(COUNTIF(D36:D606,"$L5$L6$L7"))+(COUNTIF(H36:H 606,"hC"))
Trying to count the number of L5,L6,L7 in column range D36:D606, for a total
count. Then I want that total number of L5,L6,L7 (one sum)to display the
total hC count shown in column H36:H606. I can't seem to get the total
number of hC for L5,L6,L7.