Thread: sumproduct and sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Boris75 Boris75 is offline
external usenet poster
  
Posts: 2
Default sumproduct and sumif
can I use sumproduct, concatenate text and sum column? Here's what I wrote,
but returns diverr....
=CONCATENATE(SUMPRODUCT(--(data!B:B=E5&"-"&D5)*data!H:H))
is this possible?
Reply With QuoteReply With Quote