View Single Post
  #1   Report Post  
karenm
 
Posts: n/a
Default using sumif formula: but requiring satisfying 2 if statements

columnA column b column c
c rent a 600
c name a ken
c rent b 200
c name b tom
p rent c 800
p name c bill

i want to sumif (column c) ... if column a is = a AND column b = "rent"