Posted to microsoft.public.excel.misc

Mark

external usenet poster

Posts: 989

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumproduct with text	Teethless mama	Excel Worksheet Functions	0	February 26th 09 04:09 PM
sumproduct text	A.Mourice[_2_]	Excel Worksheet Functions	5	September 2nd 08 10:31 AM
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t	zzxxcc	Excel Worksheet Functions	2	August 26th 08 11:04 PM
Text in SUMPRODUCT	J. Trucking	Excel Worksheet Functions	5	March 12th 08 12:18 AM
SUMPRODUCT but with text containing	Fiona	Excel Worksheet Functions	5	November 24th 06 09:46 AM

All times are GMT +1. The time now is 05:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us