subtotal if =1

[NateD1]

Hi All,

im trying to sum only visible rows in a filtered range using subtotal, however i need to sum only if value equal to 1.
can someone help me with a formula for this please.

thanks

 

[maabadi]

Try this:

Book1
	A	B	C	D	E
1	ID	Numbers
2	AAAA1	0		2
4	AAAA1	2
6	AAAA1	1
8	AAAA1	0
10	AAAA1	2
12	AAAA1	1
14	AAAA1	0
16
17
Sheet1

Cell Formulas
Range	Formula
D2	D2	=SUMPRODUCT(($B$2:$B$15=1)*(SUBTOTAL(103,OFFSET($B$2,ROW($B$2:$B$15)-MIN(ROW($B$2:$B$15)),0))))

 

[NateD1]

Works perfectly, Thankyou!!

 

[maabadi]

You're welcome & Thanks for feedback.