Thread: SUMPRODUCT won't work on a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
  
Posts: 5,441
Default SUMPRODUCT won't work on a row
You need to transpose your array:

=SUMPRODUCT(--(A10:U10={"P";"B";"S";"V";"H";"PBSVH"}))

Note the semicolons instead of commas....

HTH,
Bernie
MS Excel MVP


"PFB" wrote in message
...
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