SUMPRODUCT & TEXT
 

=SUMPRODUCT((O2:HF2=1)*(O$1:HF$10)*($O$1:$HF$1=TR ANSPOSE(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?

SUMPRODUCT & TEXT
 

No, SUMPRODUCT only returns numeric values.

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

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...
=SUMPRODUCT((O2:HF2=1)*(O$1:HF$10)*($O$1:$HF$1=TR ANSPOSE(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?

SUMPRODUCT & TEXT
 

"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?

"T. Valko" wrote:

No, SUMPRODUCT only returns numeric values.

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

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...
=SUMPRODUCT((O2:HF2=1)*(O$1:HF$10)*($O$1:$HF$1=TR ANSPOSE(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?

SUMPRODUCT & TEXT
 

I believe that text values first have to be coerced in to 0 or 1 before
processing them using the double unary -- take a look here 'SUMPRODUCT
And Other Array Functions - VBA Express Forum'
(http://www.vbaexpress.com/forum/forumdisplay.php?f=98) for a fantastic
question and answer tutorial on SUMPRODUCT by Bob Phillips MVP

Mark;319429 Wrote:
"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?

"T. Valko" wrote:

No, SUMPRODUCT only returns numeric values.

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

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...

=SUMPRODUCT((O2:HF2=1)*(O$1:HF$10)*($O$1:$HF$1=TR ANSPOSE(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?





--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=89076