SUM of areas
=SUMIF(A:A,"AB",B:B)
You van put AB in a cell and reference that cell as well.
--
__________________________________
HTH
Bob
"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
|