View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bassman62 Bassman62 is offline
external usenet poster
 
Posts: 117
Default How to write an Or statement inside Sumproduct?

Using xl-2007
I reallize that the OR statement cannot be used as an array in a Sumproduct.
In this case how can I sum the values in column D or count the rows where
columns A & B = t and column C = x Or y?

A B C D
1 t t x 10
2 t f x 5
3 t t y 10

Thanks.