Hi Mike

Use a pivot table for this, don't fiddle with formulas. Faster, safer, more
fun, more power.

Best wishes Harald

"Mike" wrote in message
...
Hi everone,

Say I have this:
A B C
1 a1 9
1 a2 10
1 a3 11
1 a1 12
1 a3 13
1 a3 14
2 a1 15
2 a2 16
2 a1 17
2 a2 18
2 a3 19

I want the sum of C values for each value of (A and B). For example,
A=1, B=a3, then C=11+13+14=38. Smart formula to do this please?

Thanks,
Mike