Multiply rows based on Multiple Criteria

Hi all,

Any idea for this formula

A * B + A1*B1 + .... divide (/) total B


Column A Column B Column C Formula
Sony A 10
Sony B 5
Sony A 9
Sony B 6



I want in the Formula Column

if Column A = Sony then
[(Column B -> A -> Column C 10 )*(Column B -> B -> Column B 6 )] / TOTAL Column B -> B

(10*5)+(5*6)/(5+6)

Thanks

Originally Posted by nflsales

If always B is followed by A then the below formula will work

=SUMPRODUCT((A1:A3="Sony")*(B1:B3="A")*(C1:C3)*(A2:A4="Sony")*(B2:B4="B")*(C2:C4))/SUMIFS(C1:C4,A1:A4,"Sony",B1:B4,"B")

Hi,

Ya, I able to do it. But now my source is more than as below

Column A Column B Column C
SONY OPENING 10
SONY PRODUCTION 9
SONY SALES PLAN 6
SONY CLOSING 8
SONY ACTUAL SALES 11
SONY TARGET COVERAGE 23
SONY ACTUAL COVERAGE 30
SONY OPENING 10
SONY PRODUCTION 9
SONY SALES PLAN 6
SONY CLOSING 8
SONY ACTUAL SALES 11
SONY TARGET COVERAGE 23
SONY ACTUAL COVERAGE 30
SONY OPENING 10
SONY PRODUCTION 9
SONY SALES PLAN 6
SONY CLOSING 8
SONY ACTUAL SALES 11
SONY TARGET COVERAGE 23
SONY ACTUAL COVERAGE 30
SONY OPENING 10
SONY PRODUCTION 9
SONY SALES PLAN 6
SONY CLOSING 8
SONY ACTUAL SALES 11
SONY TARGET COVERAGE 23
SONY ACTUAL COVERAGE 30
PANASONIC OPENING 10
PANASONIC PRODUCTION 9
PANASONIC SALES PLAN 6
PANASONIC CLOSING 8
PANASONIC ACTUAL SALES 11
PANASONIC TARGET COVERAGE 23
PANASONIC ACTUAL COVERAGE 30

Originally Posted by nflsales

If always B is followed by A then the below formula will work

=SUMPRODUCT((A1:A3="Sony")*(B1:B3="A")*(C1:C3)*(A2:A4="Sony")*(B2:B4="B")*(C2:C4))/SUMIFS(C1:C4,A1:A4,"Sony",B1:B4,"B")

Hi,

Ya, I able to do it. But now my source is more than as below

Column A Column B Column C
SONY OPENING 10
SONY PRODUCTION 9
SONY SALES PLAN 6
SONY CLOSING 8
SONY ACTUAL SALES 11
SONY TARGET COVERAGE 23
SONY ACTUAL COVERAGE 30
SONY OPENING 10
SONY PRODUCTION 9
SONY SALES PLAN 6
SONY CLOSING 8
SONY ACTUAL SALES 11
SONY TARGET COVERAGE 23
SONY ACTUAL COVERAGE 30
SONY OPENING 10
SONY PRODUCTION 9
SONY SALES PLAN 6
SONY CLOSING 8
SONY ACTUAL SALES 11
SONY TARGET COVERAGE 23
SONY ACTUAL COVERAGE 30
SONY OPENING 10
SONY PRODUCTION 9
SONY SALES PLAN 6
SONY CLOSING 8
SONY ACTUAL SALES 11
SONY TARGET COVERAGE 23
SONY ACTUAL COVERAGE 30
PANASONIC OPENING 10
PANASONIC PRODUCTION 9
PANASONIC SALES PLAN 6
PANASONIC CLOSING 8
PANASONIC ACTUAL SALES 11
PANASONIC TARGET COVERAGE 23
PANASONIC ACTUAL COVERAGE 30