Hi All,
In columnA starting at row 29, I have the date repeated down many rows.
In columnQ commencing at row 29, I have positive and negative numbers.
How can I find the sum of columnQ which corresponds to the repeated date in A.
Example:
ColA ColQ
10/6/06 -6
10/6/06 8
10/6/06 15
10/6/06 -3
Answer: 10/6/06 is 14
Could anyone help please.
Regards,
RC
In columnA starting at row 29, I have the date repeated down many rows.
In columnQ commencing at row 29, I have positive and negative numbers.
How can I find the sum of columnQ which corresponds to the repeated date in A.
Example:
ColA ColQ
10/6/06 -6
10/6/06 8
10/6/06 15
10/6/06 -3
Answer: 10/6/06 is 14
Could anyone help please.
Regards,
RC