Problem with summing IF functions (not SUMIF)

[Jovica]

Hi,

what I would like to do, is to somehow sum all this values = (A1/$A$8)*B1 if C3 is "B".... If I would have only 7 values (like it this example - A1:A7) then I could simply use =IF(C1="B",(A1/A8)*B1,"")+IF(C2="B", (A2/A8)*B2... But the problem is that my sheet has more then 50 rows.

I've attached example worksheet.Book1.xlsx

Any help would be appreciated.

[JosephP]

=SUMPRODUCT(--(C1:C7="B"),A1:A7,B1:B7)/A8
oughta do it

[Jovica]

Thank you so much, it works.
Could you please explain to me what "--" after sumproduct does.

[JosephP]

it converts true and false values into 1 and 0 which the sp formula then uses in its multiplication
good explanation here: http://www.xldynamic.com/source/xld....T.html#explain

[Jovica]

Thank you.