Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with two or more variables
I am trying to use the SUMIF function with two variables.
What I have is a worksheet with multiple columns. Let's say columns A and B have data (names) and column C has numbers. What I want to do is check for criteria in columns A and B and add column C if they match. Job Skill Type Hours abc wri 3 xyz wri 2 abc ill 3 xyz wri 5 abc wri 3 On a seperate worksheet in the same workbook I want it to determine the total hours that "abc" worked "wri" only. I have tried to imbed an AND function as part of the SUMIF function but can't get it to work. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with two or more variables
=SUMPRODUCT(--(A2:A10="abc"),--(B2:B10="wri"),C2:C10)
for better usability replace abc and wri with cell references =SUMPRODUCT(--(A2:A10=D2),--(B2:B10=E2),C2:C10) then instead of editing the formula when you want to change names just change the contents of D2 and E2 -- Regards, Peo Sjoblom "B Benton" <B wrote in message ... I am trying to use the SUMIF function with two variables. What I have is a worksheet with multiple columns. Let's say columns A and B have data (names) and column C has numbers. What I want to do is check for criteria in columns A and B and add column C if they match. Job Skill Type Hours abc wri 3 xyz wri 2 abc ill 3 xyz wri 5 abc wri 3 On a seperate worksheet in the same workbook I want it to determine the total hours that "abc" worked "wri" only. I have tried to imbed an AND function as part of the SUMIF function but can't get it to work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF formula for two variables in two columns | Excel Worksheet Functions | |||
Sumif with multiple variables | Excel Discussion (Misc queries) | |||
SUMIF Formuale with 2 variables | Excel Worksheet Functions | |||
How do I set up a nested SUMIF formula for a number of variables? | Excel Worksheet Functions | |||
SUMIF variables | Excel Discussion (Misc queries) |