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 |
All times are GMT +1. The time now is 07:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com