View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bobito
 
Posts: n/a
Default Sumif function with multiple criteria

I am trying to "sum" a column using "sumif" ... but need to use 2 criteria.
I have tried the Sumif(And(< cond 1 , cond 2 )(ans) but this does not work.
Has anybody any idea how write the correct statement