Use SUMIF

=SUMIF(A$2:A$10,"AB",B$2:B$10)

D2 = AB

=SUMIF(A$2:A$10,D2,B$2:B$10)

--
Biff
Microsoft Excel MVP


"Natalie" wrote in message
...
Hi there, I have a list of invoices with postcodes, and I want to know the
amount per postcode. For example.

Column A Column B
Postcode Invoice amount
AB £600
CH £40
AB £50
CH £30
SO £100
SG £40
SO £200
CH £300

And I want to know the total of each postcode but without using a pivot
chart?
Can anyone help? I think I need SUMPRODUCT but I'm not sure.

Thanks

Natalie