Sum Function Needed

[robcarr]

Dear All

I have a client and they want to know the sum of column c if column a and B are both true, would this be easier to create a custom function or can a formula do the trick. here is an example of the data I want to work with

rob carr 2
rob van 3
rob van 3
rob carr 2

the results would be rob carr = 4 and rob van = 6, this is because rob is found and carr is found so it sums the values for each find in C and ends up with 4.




Thanks Rob.

 

[robcarr]

I have used sumproduct and it works a treat

Thanks Rob.