var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: excel help pls!
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=?
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,