help with sumif formula with multiple critera

[Guest]

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

 

[SteveG]

Matt,

You could use SUMPRODUCT instead.

=SUMPRODUCT(--(A2:A373=V10),--(B2:B373=M10),(I2:I373))

HTH

Stev

 

[Bruno Campanini]

Matt,

You could use SUMPRODUCT instead.

=SUMPRODUCT(--(A2:A373=V10),--(B2:B373=M10),(I2:I373))

Or, if you want to use directly a date and a name:
=SUMPRODUCT((D6770=VALUE("10-02-1936"))*(E67:E70="BC"),(F67:F70))

Bruno

 

[Guest]

This is exaclty what i needed thanks

Or, if you want to use directly a date and a name:
=SUMPRODUCT((D6770=VALUE("10-02-1936"))*(E67:E70="BC"),(F67:F70))

Bruno

 

[Guest]

Bruno -
Thank you, this solved the problem I was having.