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

help with sumif formula with multiple critera
 

Matt,

You could use SUMPRODUCT instead.

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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=506811

help with sumif formula with multiple critera
 

"SteveG" wrote in
message ...

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((D67:D70=VALUE("10-02-1936"))*(E67:E70="BC"),(F67:F70))

Bruno

help with sumif formula with multiple critera
 

This is exaclty what i needed thanks


"Bruno Campanini" wrote:

"SteveG" wrote in
message ...

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((D67:D70=VALUE("10-02-1936"))*(E67:E70="BC"),(F67:F70))

Bruno

help with sumif formula with multiple critera
 

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


"Bruno Campanini" wrote:

"SteveG" wrote in
message ...

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((D67:D70=VALUE("10-02-1936"))*(E67:E70="BC"),(F67:F70))

Bruno