ExcelBanter - summing transactions based on date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - summing transactions based on date (https://www.excelbanter.com/excel-discussion-misc-queries/231847-summing-transactions-based-date.html)

bobby769

summing transactions based on date

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

summing transactions based on date

"bobby769" wrote:
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

summing transactions based on date

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

"bobby769" wrote:

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.

All times are GMT +1. The time now is 02:03 PM.