Thread: sumproduct and sumif
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default sumproduct and sumif
=SUMIF(B:B,E5&"-"&D5,H:H)


"Boris75" wrote:

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