View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt
 
Posts: n/a
Default help with sumif formula with multiple critera

I cant get this formula to compute what I need. it works perfectly with only
one critera but I need more, We'll say colom A is a date, colom B is a name
and colom I is a value, I need a formula that sums only when the date is X
AND the name is Y. This sheet is used for calculating flight time on specific
tail numbers on specifc days. I an get the formula to work when it is
=SUMIF($B$2:$B$373,M10,$I$2:$I$373) but I cant get it to do both
=SUMIF($a$:$a$373,v10,$I$2:$I$373), where V10 is a specific date, M is the
Name, the date range is in A, and the value is in I

thanks for the help