Sumproduct Question

[Selo]

Hello

I got 2 sheets
1 contains the dates the other the info
I allready tryed something but it doesn't work (see attechment)

at sheet2 row2, row3 is correct but at the date 08-01-07 it takes the info from the the date 07-01-07 (dd-mm-yy)

can anyone help me?

[Selo]

Somproduct = Sumprodukt

[daddylonglegs]

Your formula syntax isn't quite right. Try this formula in B2 copied down

=SUMPRODUCT(--(Blad1!$A$2:$A$19=A2),Blad1!$B$2:$B$19)

although for a single criterion like this SUMIF is better and faster

=SUMIF(Blad1!$A$2:$A$19,A2,Blad1!$B$2:$B$19)

[Selo]

Thank you very much
They both work perfectly