Thread
:
SUMIF with two or more variables
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
external usenet poster
Posts: 3,268
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 With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom