Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jerry Kinder
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"