SUMPRODUCT & TEXT

[Mark]

=SUMPRODUCT((O2:HF2=1)*(O$1:HF$1>0)*($O$1:$HF$1=TRANSPOSE(TG!$A$3:$A$202)),(TRANSPOSE(TG!$U$3:$U$202)))
entered as an array (CTRL+SHIFT+ENTER). If the values in column U is text, I
get nothing, if Numeric, I get the Numeric value. Is there a way to make it
grab text?

 

[T. Valko]

No, SUMPRODUCT only returns numeric values.

What do you mean by "make it grab text"?

 

[Mark]

"Grab Text" slang - the formula will grab (show) numberic, but not a text
value. I verified the formula by replacing the "text" values column U with
numeric. The odd thing is, in my formula, all of the other references are
looking at "Text" values. Is there another solution that would compare
multiple Text values, and find/display a text value?