Sum based on two conditions
Thank you so very much for your kind help. I appreciate it.
"JMB" wrote:
If your data is in A1:C9 and
A13 = T1
A14 = T2
A15 = T3
Enter this in B13 (Confirmed with Control+Shift+Enter after typing it into
the formula bar-if you do it right excel will put braces { } around the
formula) and copy down.
=SUM(($A$1:$A$9=A13)*($C$1:$C$9=LARGE(IF($A$1:$A$ 9=A13,$C$1:$C$9,0),2))*($B$1:$B$9))
"luvgreen" wrote:
Hello! Please help with data below - sum col B based on top 2 of col C and
group by Col A. T1=70+100=170, T2 = 400+300=700, T3=150+110=260
Thank you so much for helping.
Col A Col B Col C
T1 100 20%
T3 150 15%
T2 400 30%
T1 400 10%
T1 70 50%
T2 120 18%
T1 150 15%
T2 300 30%
T3 110 10%
|