View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pgarcia pgarcia is offline
external usenet poster
 
Posts: 304
Default Should this work? =SUMPRODUCT( --($K$3:$K$4650&D3),...

=SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), --($M$3:$M$4650))

or

=SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), ($M$3:$M$4650))

or

=SUMPRODUCT( --($K$3:$K$4650=D3), --($L$3:$L$4650=$F$2), --($M$3:$M$4650))