View Single Post
  #1   Report Post  
ShaneS
 
Posts: n/a
Default Can SUMIF function include AND function

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.