Excel Formula Help -Filtered Row

[ststern45]

Hi everyone,

I'm looking for a formula that will count how many times a number appears from a filtered column.

For example, Cell Range A2:A1001

I have multiple values of 000 in cell range A2:A1001

Once I filter another Row I want to count how many times the 000 (or any value) appears in cell range A2:A1001

Thank you

 

[jorismoerings]

Hi,

Take a look at this and see if this helps:

Book1
	A	B	C	D
1	1	3		1
3	0
5	0
6	000
8	0
9	0
11	0
Sheet14

Cell Formulas
Range	Formula
D1	=SUMPRODUCT((A2:A1001="000")*(SUBTOTAL(103,OFFSET(A2,ROW(A2:A1001)-MIN(ROW(A2:A1001)),0))))

 

[Aladin Akyurek]

Book1
	A	B	C	D	E	F	G
1
2	1					000	2
3	0					0	4
4	0
5	000
6	0
7	000
8	0
Sheet1

In G2 control+shift+enter, not just enter, and copy down:

=SUMPRODUCT(SUBTOTAL(3,OFFSET($A$2,ROW($A$2:$A$8)-ROW($A$2),0)),IF(ISNUMBER(F2),($A$2:$A$8=F2)+0,ISNUMBER(FIND(F2,$A$2:$A$8))+0))

 

[ststern45]

Thanks for all the help.