MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding totals per code


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
using your example data then

=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