crapit

=SUMIF(A1:A8,"AR",B1:B8)

If you don't know the range you can use

=SUMIF(A:A,"AR",B:B)


Gord Dibben Excel MVP



On Fri, 25 Nov 2005 09:01:09 +0800, "crapit" wrote:

A B

1 AR 21.40
2 AL 400.00
3 AL 100.00
4 AR 8.90
5 AR 16.90
6 AR 42.00
7 PS 30.00
8 PS 40.00



How to add up column "B" value if the corresponding value in column "A"
equal AR ???