# Help with a formula please!

Closed
einfald Posts 1 Registration date Tuesday December 3, 2013 Status Member Last seen December 4, 2013 - Dec 4, 2013 at 12:06 AM
einfald - Dec 5, 2013 at 02:23 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 5, 2013 at 12:39 AM
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.