Thread: sumproduct formula work around
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
  
Posts: 71
Default sumproduct formula work around
Is there any way to replicate this formula with countif or sumif and
not using the array (ctr shift enter) function?

=SUMPRODUCT((A19:A357=A7)*(Y19:Y357=1))
Reply With QuoteReply With Quote