Some sort of count formula

[Christian11]

Does anyone know how I can count the total number of customers who filled in a cell? For example with customer A, even though they responded to question 1&2, I only want the count to be 1.

If the values in the cells were numbers, my formula would be =SUMPRODUCT((B2:B4+C2:C4+D2:D4>0)+0)

But since the cells are text, I can’t use SUMPRODUCT

 

[KRice]

Try this...

Book1
	A	B	C	D	E	F
1		Q1	Q2	Q3		3
2	A	Yes	No
3	B
4	C	Yes		Yes
5	D		Maybe
Sheet5

Cell Formulas
Range	Formula
F1	F1	=SUM(SIGN(MMULT(--(B2:D5<>""),{1;1;1})))

This determines the number of non-blanks on each row and then converts any non-zeroes to a 1 before summing. If you have more Questions (columns), adjust the size of the 1's array to match.

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Some sort of count formula
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.