Sum of Rows based on Criteria of another cell

[sahaider]

10	1
15	0
20	1
10	0
25	1
10	0

<tbody>
</tbody>

Hello ,

I have two column of data. In first column I have data i each row. In 2nd column i have data (=1)in selected rows. I want to sum entries in first column based on entries in rows of the 2nd columns where data =1. I data =blank then exclude that row from summation.

Pleas advise.

Regards
Syed

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D
1	10	1
2	15	0
3	20	1		55
4	10	0
5	25	1
6	10	0
Data

Cell Formulas
Range	Formula
D3	=SUMIF(B1:B6,1,A1:A6)

 

[sahaider]

How about

Excel 2013/2016

	A	B	C	D
1	10	1
2	15	0
3	20	1		55
4	10	0
5	25	1
6	10	0

<colgroup><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Data​

Worksheet Formulas Cell Formula D3 =SUMIF(B1:B6,1,A1:A6) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

hello Fluff,

Thanks.
Regards
Syed

 

[Fluff]

You're welcome