Try this instead

=SUMPRODUCT((Daily!$B$5:$B$3000=D21)*(Daily!$E$5:$ J$3000))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Jerry Kinder" wrote in message
...
Hi,
I have this formula =SUMIF(Daily!$B$5:$B$3000,D21,Daily!$E$5:$J$3000) and
it
only sums col E, not E,F,G,H,I, and J. I have tried Ctrl, Shift, Enter
also.
Col B is dates, D is dates ( in a different sheet), and E:J are amounts.

What have I done wrong??
Thank you.
Jerry