Posted by Loes on July 18, 2000 2:21 AM

Hi there,

I'm trying to get this working:

Code Amount
A 10
B 100
A 20
C 35
D 90
E 21
E 40
B 10

Total for A : Summarize all amounts with code A
Total for B : Summarize all amounts with code B
Total for C : Summarize all amounts with code C
Total for D : Summarize all amounts with code D
Total for E : Summarize all amounts with code
Total for all : All totals

Can someone help me? Many thanks in advance!

Grtx,

Loes

Posted by Ivan Moala on July 18, 0100 2:55 AM

Hi Loes
try using the SumIf function eg.
Asuming data in columns A & B starting @ A3 and

=SUMIF(A\$3:A\$10,"=A",B\$3:B\$10) for A
=SUMIF(A\$3:A\$10,"=B",B\$3:B\$10) for B
=SUMIF(A\$3:A\$10,"=C",B\$3:B\$10) FOR C
=SUMIF(A\$3:A\$10,"=D",B\$3:B\$10) FOR D
=SUMIF(A\$3:A\$10,"=E",B\$3:B\$10) FOR E
=SUMIF(A\$3:A\$10,"=*",B\$3:B\$10) FOR TOTAL

hth

Ivan

Posted by Loes on July 18, 0100 6:37 AM

Thanks Ivan

Hello Ivan,

Just wanted to say: Thanks again! That's the third time you helped me out! Many thanks!

Grtx,
Loes