Help With counting rows with multiple criteria

Hello kbrand888. Welcome to the forum.

With data as below try this formula.

Formula:

Please Login or Register  to view this content.

This formula is specific to 5 columns. Adjust as necessary.

	A	B	C	D	E	F	G
1	Yes	no	no	Yes	Yes	9	In F1: =SUMPRODUCT(--(MMULT(--($A$1:$E$17="Yes"),{1;1;1;1;1})>=3))
2	Yes	Yes	no	Yes	Yes
3	Yes	no	Yes	Yes	no
4	no	no	no	Yes	no
5	no	Yes	no	Yes	no
6	no	Yes	Yes	no	Yes
7	Yes	no	no	no	Yes
8	Yes	Yes	Yes	no	no
9	no	Yes	Yes	no	no
10	Yes	no	Yes	Yes	no
11	no	Yes	Yes	Yes	no
12	no	Yes	no	Yes	no
13	no	no	Yes	no	Yes
14	no	Yes	Yes	no	Yes
15	no	Yes	Yes	no	no
16	no	Yes	Yes	no	Yes
17	Yes	Yes	no	no	no

Yes. It's easier if you use a Table. If you are not aware of it Tables size themselves automatically to fit the data. Then you could reference the table by name using ...

Formula:

Please Login or Register  to view this content.

If you have never used Tables before it is a good idea to supply your preferred headers above the yes/no columns. Otherwise Excel provides the default Column1, Column2 ...


And BTW please refrain from quoting whole posts. It's just clutter. A few lines relevant to your post is sufficient. Thanks

	A	B	C	D	E	F	G
1	Resp1	Resp2	Resp3	Resp4	Resp5	9	In F1: =SUMPRODUCT(--(MMULT(--(Table1="Yes"),ROW(INDIRECT("1:"&COLUMNS(Table1)))^0)>=3))
2	Yes	no	no	Yes	Yes
3	Yes	Yes	no	Yes	Yes
4	Yes	no	Yes	Yes	no
5	no	no	no	Yes	no
6	no	Yes	no	Yes	no
7	no	Yes	Yes	no	Yes
8	Yes	no	no	no	Yes
9	Yes	Yes	Yes	no	no
10	no	Yes	Yes	no	no
11	Yes	no	Yes	Yes	no
12	no	Yes	Yes	Yes	no
13	no	Yes	no	Yes	no
14	no	no	Yes	no	Yes
15	no	Yes	Yes	no	Yes
16	no	Yes	Yes	no	no
17	no	Yes	Yes	no	Yes
18	Yes	Yes	no	no	no