Thread: SUMPRODUCT & TEXT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Mark is offline
external usenet poster
  
Posts: 989
Default 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 QuoteReply With Quote