Hi,

I think i am doing this the long way using VBA but there must be a quicker way using formulas???

I have 3 columns of data

A B C
1 Alan 22
1 Alan 10
2 Carl 4
1 Brian 67
1 Alan 8
3 Brian 2

Can i do a formula that totals Column C if Column "A" = 1 and Column "B" = "Alan"

So If i did this for Column A = 1 and Column B = Alan the sum total would be 40.

There must be a formula/combination of formulas that can do this.

Thanks