excel help pls! [Archive]

alazarou

08-01-03, 04:44

How can I sum (in C Column) the values from the A Column which the character “AU” is in B Column and the same for the “BU” character?

A B C
1 AU sumAU=?
5 AU sumBU=?
45 BU
2 AU
9 BU

Thanks,
@lazarou

rwcplw

08-02-03, 11:52

You should use the =SumIf() Worksheet Function.

It has the structure of =SumIf(EvaluateRange, CriteriaValue, SumRange)

In your case:
EvaluateRange is the B column
CriteriaValue is "AU" (or "BU" or whatever).
SumRange is the A column.

So, =SumIf(B1:B5,"AU",A1:A5) would conditionally sum the values in cells A1:A5.

Hope this helps,
Mike