sumif ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry Kinder - 09 May 2006 22:11 GMT

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

Reply to this Message

Peo Sjoblom - 09 May 2006 22:35 GMT

Try this instead

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

Signature

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

> Hi,
> I have this formula =SUMIF(Daily!$B$5:$B$3000,D21,Daily!$E$5:$J$3000) and
[quoted text clipped - 6 lines]
> Thank you.
> Jerry

Reply to this Message

Jerry Kinder - 10 May 2006 17:41 GMT

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

> Try this instead
>
[quoted text clipped - 10 lines]
> > Thank you.
> > Jerry

Reply to this Message

Peo Sjoblom - 10 May 2006 18:36 GMT

Thanks for the feedback

Peo

> Hi Peo,
> It works perfectly, Thank you so much.
[quoted text clipped - 17 lines]
>> > Thank you.
>> > Jerry

Reply to this Message