Condition Sum

[Gos-C]

Hello,

I need a formula to sum Column C when the data across Columns E, F an
G haven't already appeared. In other words, if the data across Column
E, F and G is listed more than once, Column C is counted once only.



100
300
300
200
400
400
100



A
B
B
A
X
X
Y



1111000000
4400111111
4400111111
1111000000
4611000000
4611000000
1515000000



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-

 

[Guest]

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]

Rows 2 and 3 are the same, and rows 5 and 6 are the same. Therefore, we
are summing rows 1, 2, 4, 5 and 7. We are not summing duplicates.

Gos-C

 

[via135]

hi!

assuming your data in A17
use Advance Filer > list range "A17"
criteria range -leave blank-

check "Unique Records only"
check "copy to other location" range "of your wish"

the uniqe records will be copied down to a new location.
use "auto sum"

-via135