Help with a formula please!

[Closed]
Report
Posts
1
Registration date
Tuesday December 3, 2013
Status
Member
Last seen
December 4, 2013
-
 einfald -
Hi. New to this but it seems like a good forum. I NEED HELP PLEASE! I will try to explain my dilemma. In Excel if there is a specific day/date in a cell, and an amount of $ in another cell I would like to transfer that data to a separate spreadsheet and have it add those dollars by date. Possible? Thanks to anyone who can assist.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
suppose date in col A and B from A1 are like this
date amount
9-Dec-13 1
10-Dec-13 2
11-Dec-13 3
10-Dec-13 4
11-Dec-13 5
1-Dec-13 6
10-Dec-13 7

in C2 (repeat C2)type this formula and copy down

=IF(AND(COUNTIF($A$2:OFFSET(A$1,COUNTA(A:A)-1,0,1,1),A2)>=1,COUNTIF(A2:$A$2,A2)=1),SUMPRODUCT(($A$2:OFFSET(A$1,COUNTA(A:A)-1,0,1,1)=A2)*($B$2:OFFSET(A$1,COUNTA(A:A)-1,1,1,1))),"x")

is this col. C you want?
Hi. Thank you very much for your response and time. What I am looking for is as in your example, columns A3 and A5 to add up to 8 in column C? Thanks.