Is there a quicker way to do this

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

I'll assume that you want this count to change, so I'll assume that in Cells E1 and E2 you can select a number (corresponding to column A) and a name (corresponding to column B). So in this case, E1 would be "1" and E2 would be "Alan".

Now in column D1, I would put this code and drag it down.

Please Login or Register  to view this content.

This code will create a column with the values from column C if they meet the criteria you specified in E1 and E2.

Then just create a

Please Login or Register  to view this content.

formula whereever you want the total.

Hi

=SUMPRODUCT(--(A1:A6=1),--(B1:B6="Alan"),C1:C6)

the critertia can be cell references holding the criteria values.

Richard