summing transactions based on date

[bobby769]

I have dates of transactions in Column A,
the dates are not consecutive since some dates did not have transactions,
amounts are listed in column B.

How do i add up the amounts based on dates.
Cell C1 would be the 'from date' and D1 would be the 'to date'
E1 would contain the answer.

 

[JoeU2004]

I have dates of transactions in Column A,
the dates are not consecutive since some dates did not have transactions,
amounts are listed in column B.

How do i add up the amounts based on dates.
Cell C1 would be the 'from date' and D1 would be the 'to date'
E1 would contain the answer.

One way:

=sumproduct((C1<=A1:A100)*(A1:A100<=D1),B1:B100)

 

[JoeU2004]

I have dates of transactions in Column A,
the dates are not consecutive since some dates did not have transactions,
amounts are listed in column B.

How do i add up the amounts based on dates.
Cell C1 would be the 'from date' and D1 would be the 'to date'
E1 would contain the answer.

One way:

=sumproduct((C1<=A1:A100)*(A1:A100<=D1),B1:B100)

 

[Jacob Skaria]

Using SUMIF ..the below will give you sum inclusive of both dates..

=SUMIF(A:A,">=" &C1,B:B)-SUMIF(A:A,">" &D1,B:B)

If this post helps click Yes

 

[Jacob Skaria]

Using SUMIF ..the below will give you sum inclusive of both dates..

=SUMIF(A:A,">=" &C1,B:B)-SUMIF(A:A,">" &D1,B:B)

If this post helps click Yes