Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |