Hi, I am new here. Need help on the below.

I am trying to sum up the value on column B with the condition as below
1) text value at column C start with "a*"
2) only sum one value in respect to colunm A

Basically what the result i want should be 800+900=1700

I am using excel 2003.

A B C
1 800 aa
1 800 bc
1 800 aa
1 800 aa
1 800 fg
1 800 aa
2 900 ab
2 900 dd
2 900 ee
2 900 ab
2 900 ab
2 900 ab
2 900 ab