Calculate sumproduct for block of rows in a column based on a condition.

[Ranjith_SP]

Hi,
i have 4 columns.
ColumnA has multiple row blocks each having row ID from 1 to any value.
i want to display sumproduct for columnB and ColumnC in ColumnD for each row block when ColumnA is equal to 1.
Please help.

Thanks for any help!!!

 

[Marcelo Branco]

Welcome to Mr Excel forum

Maybe something like this

Pasta2
	A	B	C	D
1	Column A	Column B	Column C	Result
2	1	10	10	900
3	2	10	10
4	3	10	10
5	4	10	10
6	5	10	10
7	6	10	10
8	7	10	10
9	8	10	10
10	9	10	10
11	1	10	10	1000
12	2	10	10
13	3	10	10
14	4	10	10
15	5	10	10
16	6	10	10
17	7	10	10
18	8	10	10
19	9	10	10
20	10	10	10
21	1	10	10	800
22	2	10	10
23	3	10	10
24	4	10	10
25	5	10	10
26	6	10	10
27	7	10	10
28	8	10	10
29
Plan3

Cell Formulas
Range	Formula
D2:D28	D2	=IF(A2=1,SUMPRODUCT(B2:B$100,C2:C$100)-SUM(D3:D$100),"")

M.

 

[Ranjith_SP]

Thank you @Marcelo Branco for the solution.?

 

[Marcelo Branco]

You're welcome. Glad to help

M.