SUMIF funkcion example
Excel help is quite good for this function
Range = The range to evaluate
Criteria = What to evaluate that range for
Sum Range = The range to sum if the criteria evaluates as true
So for numbers in a range try
=SUMIF(A1:A6,"="&22,B1:B6)
or text try
=SUMIF(A1:A6,"=a",B1:B6)
Mike
"vava" wrote:
I have to use SUM IF Funkcion, and I am not sure how. What to put in Range,
Criteria and Sum_range?
|