Home |
Search |
Today's Posts |
#1
|
|||
|
|||
On second thought ...
Hi,
Thanks, I will try it this weekend after the holiday is over. JK "tjtjjtjt" wrote in message ... You might try this instead. I tested my first formula this morning and got an incorect result. =SUMPRODUCT(--(A1:A100=C1),--(A1:A100<=D1),B1:B100) tj "Jerry Kinder" wrote: Hi, Col A has dates in order Col B has amounts Cell D1 is the beginning date Cell E1 is the end date I want to sum Col B where the dates in ColA are between the dates in D1 and E1. Thanks for your help. Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|