You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Mosqui" wrote in message
...
That was perfect

thanks for your help.

"T. Valko" wrote:

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

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

--
Biff
Microsoft Excel MVP


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

=SUMPRODUCT(--(Details!$C$4:$C$151=Summary!G10),--(Details!$D$4:$D$151=

7) ),--(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)

--
Biff
Microsoft Excel MVP


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

7) ),--(Details!$E$4:$E$151=I10),Details!$F$4:$F$151)

How do I put it on the formula?

Thanks in advance

Mosqui


.



.