SUMPRODUCT Query with example book att

**jtwork** · 06-05-2007, 10:15 AM

I cant get the cell in column J to pick up on the data in my sumproduct query.....PLEASE HELP

Book attached

**arthurbr** · 06-05-2007, 10:22 AM

No book is attached to your post!

**jtwork** · 06-05-2007, 10:39 AM

here you go

**NBVC** · 06-05-2007, 10:44 AM

Try changing formula to:

=SUMPRODUCT(--(A2:A311="5/26/2007"+0),--(D2:D311="BR"),--(C2:C311=12),E2:E311)

**jtwork** · 06-05-2007, 10:46 AM

i tried this method but without the +0 what is the +0 doing and why do i need it?

**NBVC** · 06-05-2007, 10:47 AM

Originally Posted by jtwork

i tried this method but without the +0 what is the +0 doing and why do i need it?

It converts the date which is text (because of the quotes) to a numeric.

here you go