Sumif with 2 ranges & 2 criteria
I don't know why, but it doesn't work...it just gave me "#Name?" - maybe it's
because i don't understand the sumproduct function and how it works...is
there no way to do it with the sumif function?
"Teethless mama" wrote:
=SUMPRODUCT(--(Job_Name="Lot 27"),--(class="Labor"),Amount)
"cgibby" wrote:
Hi, I have been trying to figure out a way to use the sumif with 2 criteria &
2 ranges...here is what it looks like
Name Job Name Class Amount
Lee Bolding Const Lot 27 Labor 1000
Tom Moran lot 25 Labor 5000
Seneca Hardwood lot 27 materials 2000
I want a formula that gives me the total amount of all job names containing
"lot 27" in which contain the class "labor". I have been able to get the
total amount of just lot 27, but not 2 different criteria.
Can you help?
|