sumif ?

Jerry Kinder · May 9, 2006

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

Peo Sjoblom · May 9, 2006

Try this instead

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

Jerry Kinder · May 10, 2006

Hi Peo,
It works perfectly, Thank you so much.
Regards,
Jerry

Peo Sjoblom · May 10, 2006

Thanks for the feedback

Peo

Jerry Kinder said:
Hi Peo,
It works perfectly, Thank you so much.
Regards,
Jerry