| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif ?
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif ?
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif ?
Hi Peo,
It works perfectly, Thank you so much. Regards, Jerry "Peo Sjoblom" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif ?
Thanks for the feedback
Peo "Jerry Kinder" wrote in message ... Hi Peo, It works perfectly, Thank you so much. Regards, Jerry "Peo Sjoblom" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
| SUMIF | Excel Worksheet Functions | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Hybrid Mode
