View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?