View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mosqui Mosqui is offline
external usenet poster
 
Posts: 10
Default Use extract into a condition

I have a sumproduct formula with different conditions. One of them is picking
up only the first 17 caracters of a cell. So LEFT(H10,17)

=SUMPRODUCT(--(Details!$C$4:$C$151=Summary!G10),--(Details!$D$4:$D$151=
LEFT(H10,17) ),--(Details!$E$4:$E$151=I10),Details!$F$4:$F$151)

How do I put it on the formula?

Thanks in advance

Mosqui