Forum Discussion
texasaggie0004
Sep 30, 2020Copper Contributor
Counting Rows based on certain variable combinations
Hopefully my question is clear, and I hope the attachment shows up. I have a large spreadsheet with about a dozen columns of information. I would like to count how many rows have certain cells tha...
SergeiBaklan
Oct 01, 2020Diamond Contributor
As variant
here
=SUMPRODUCT(--(MMULT(--(($B$3:$I$100=$L3:$S3)+($L3:$S3="")),{1;1;1;1;1;1;1;1})=8))