Thread: SUMPRODUCT won't work on a row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PFB PFB is offline
external usenet poster
  
Posts: 12
Default SUMPRODUCT won't work on a row
The following formula works on a column range (A1:A40), but not on a row
range (A10:U10). What have I missd?

=SUMPRODUCT(--(A10:U10={"P","B","S","V","H","PBSVH"}))
Reply With QuoteReply With Quote