Need help to summing

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

Hi wklam

kindly find the attatched file for solution

may be like this..

=SUMPRODUCT((C1:C13="a*")*(A1:A13=1)+(B1:B13)/COUNTIF(B1:B13,B1:B13&""))


Thanks

Hi Azam,

Thanks for the reply. Maybe i am not specific enough.

Actually the colunm A number is not known. Actually i try sumproduct with the condition of column C "SF*" but it added all the match so i am get a few 800s added together.

Another thing is the whole formula need to be done in 1 cell.

Do you have another solution?

Hi nawas, thanks for the reply. The column A numbers is not known to me. There is a few thousands of sets of number with 5 numbers combination. I just put this 1,2,3 as a example. The column A numbers should be be appearing in the formula

Hi anybody can help

Actually the data can be tweeted. I was thinking if i can add a column and able to identify out only 1 row to sum then i can just use the sumproduct function. So for the table below i just sumproduct with the condition of column D "a*" & column B = 1. But i am also having problem doing out the column B.

Pls help

A B C D
1 0 800 kk
1 0 800 bc
1 1 800 aa
1 0 800 dd
1 0 800 fg
1 0 800 aa
2 0 900 ee
2 0 900 dd
2 0 900 ee
2 1 900 ab
2 0 900 ab
2 0 900 ff
2 0 900 ab

Hi wklam

find the formula in enclosed file

Hi Azam,

Thanks for the formula. I more or less understand the logic. Maybe need to change abit to suit my table.

Thanks alot.