Thread: Conditional Sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 102
Default Conditional Sum

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