sum of amount on distinct counts

[#1]

I have account numbers like

AC NO   AMOUNT

1            50

1            50

2          100

2          100

3           100

I would like to have a sum on distinct account numbers, for ex: in above scenario i would like to have a total as 250, sum of amount for the

distinct accounts. Please help me.

Thanks,

Abhi

[swuehl]

Maybe

=sum( aggr( only(AMOUNT), [AC NO]))

[MK_QSL]

Try below

=SUM(AGGR(DISTINCT AMOUNT, [AC NO]))

[#4]

Check out the attached file hope it helps.

Thanks

AJ