sumif ?

[Jerry Kinder]

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]

Try this instead

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Jerry Kinder]

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

 

[Peo Sjoblom]

Thanks for the feedback


Peo

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