View Single Post
  #1   Report Post  
GateKeeper
 
Posts: n/a
Default Sum column if multiple criteria are met in adjacent cells

I have a table like this:

Column_A Column_B Column_C
03 S 100
03 T 100
02 S 100
02 T 100
04 S 100
04 T 100

I want to sum the cells in C only when A="03" and B="S". In this case, I
would expect the total to be 100.