G
Guest
How do I formulate a SUMIF function to include more than 1 condition? I need
to sum up a column based on conditions in 2 other columns. eg:
1 5 8
2 5 8
2 5 9
I need to add up values in the third column (C), when the corresponding
column A value is 2, AND column B value is 5. Answer should be 17 in this
case. In other words, how do I combine SUMIF(A:A,2,C:C) and SUMIF(B:B,5,C:C)?
Thanks in advance for your Help!
Shane.
to sum up a column based on conditions in 2 other columns. eg:
1 5 8
2 5 8
2 5 9
I need to add up values in the third column (C), when the corresponding
column A value is 2, AND column B value is 5. Answer should be 17 in this
case. In other words, how do I combine SUMIF(A:A,2,C:C) and SUMIF(B:B,5,C:C)?
Thanks in advance for your Help!
Shane.