If I understand you correctly, you want to sum column c on 3 separate
occasions - in column e, f and g. In each of these three columns you want to
sum column c only if data in the active column is not duplicated.
ie column e would sum only on the first instance of the character appearing
in that column. A, B, X and Y.
"Gos-C" wrote:
Hello,
I need a formula to sum Column C when the data across Columns E, F and
G haven't already appeared. In other words, if the data across Columns
E, F and G is listed more than once, Column C is counted once only.
C
100
300
300
200
400
400
100
E
A
B
B
A
X
X
Y
F
1111000000
4400111111
4400111111
1111000000
4611000000
4611000000
1515000000
G
02-Jan-06
02-Jan-06
02-Jan-06
07-Jan-06
22-Jan-06
22-Jan-06
31-Jan-06
Thank for your help,
Gos-C
--
Gos-C
------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=513434