Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif with 2 ranges & 2 criteria
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF ranges | Excel Worksheet Functions | |||
SUMIF using two ranges | Excel Discussion (Misc queries) | |||
Calculate a SUMIF if criteria is between 2 date ranges | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions |