Hi,

Try

=SUMIF(A$1:A$10,D1,B$1:B$10)

where the postal codes are in column A the amts in column B and the first
postal code you want to sum in D1

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Natalie" wrote:

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