I need a formula to compare names in column a with letters in column b and if a match to sum the value in c.
a b c
bill x 22
fred c 11
greg x 10
bill x 11
I need to sum column c when a=bill,b=x
I should have a result of 33 with this example.
I have tried several formulas but cannot get this result. I would appreciate any help! Thanks!
a b c
bill x 22
fred c 11
greg x 10
bill x 11
I need to sum column c when a=bill,b=x
I should have a result of 33 with this example.
I have tried several formulas but cannot get this result. I would appreciate any help! Thanks!