summing transactions based on date

B

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.
 
J

JoeU2004

bobby769 said:
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)
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top