Sum of Rows based on Criteria of another cell

[sahaider]

[TABLE="width: 500"]
<tbody>[TR]
[TD]10
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]20
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]25
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]0
[/TD]
[/TR]
</tbody>[/TABLE]
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

<colgroup><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]55[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Data​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D3[/TH]
[TD="align: left"]=SUMIF(B1:B6,1,A1:A6)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

hello Fluff,

Thanks.
Regards
Syed

 

[Fluff]

You're welcome