Use extract into a condition

[Mosqui]

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

 

[T. Valko]

=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)

Not sure what you're asking.

Your formula is syntactically correct if you remove that gap:

=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)

 

[Mosqui]

I left the gap because wasn't sure what to put there. Doesn't work.
I also need the same condition for column D but, how is the formula then?

So, how do you take the first 17 digits on the array?

$D$4:$D$151=LEFT(H10,17)

thanks for your help

 

[T. Valko]

Oh, I see... Just do the same thing to the array:

--(LEFT($D$4:$D$151,17)=LEFT(H10,17))

 

[Mosqui]

That was perfect

thanks for your help.

Oh, I see... Just do the same thing to the array:

--(LEFT($D$4:$D$151,17)=LEFT(H10,17))

--
Biff
Microsoft Excel MVP





.

 

[T. Valko]

You're welcome. Thanks for the feedback!