excel countifs only filtered data

[bizzbuzz05]

Hi,

I have a Countifs function but I need it only to do filtered data. I have tried looking up how to do the "SUMPRODUCT" but cant get it to work.

Here is the Countifs =COUNTIFS(A7:A8000,"=Female",H7:H8000,"=Always").
How would I change it to the SUMPRODUCT or another function to count only filtered data?

Thanks
Bizzbuzz05

 

[MrTwister85]

 

[MrTwister85]

its a work copy i dont have IT rights to install and add ons. So i post the picture

 

[Sufiyan97]

Wrape this part

W6:W3290<>0

in IFNA like:

--IFNA(W6:W3290<>0,0)

 

[MrTwister85]

=SUMPRODUCT(SUBTOTAL(103,OFFSET(W6,ROW(W6:W3290)-ROW(W6),0,1)),--IFNA(W6:W3290<>0,0))

gives me value error

 

[Sufiyan97]

If you can't use add-ins then just copy and paste your sample data here
Not image, as we are not able to identify what your data looks like

 

[MrTwister85]

WEEKLY CHANGE​
PPC	Forecast Start	Forecast Finish
0%​	-63d.​	-63d.​
0%​	0d.​	0d.​

 

[MrTwister85]

nvm its working! thank you!

 

[Sufiyan97]

You can see it works fine for me

Book7
	A	B	C	D	E
1
2		2
3
4	WEEKLY CHANGE
5	PPC	Forecast Start	Forecast Finish
7	A	1
8	A	0
9	A	1
10	B	0
13
14
Sheet2

Cell Formulas
Range	Formula
B2	B2	=SUMPRODUCT(SUBTOTAL(103,OFFSET(B6,ROW(B6:B3295)-ROW(B6),0,1)),--IFNA(B6:B3295<>0,0))

 

[Sufiyan97]

nvm its working! thank you!

You're welcome.

 

[MrTwister85]

is there a way that this formula would ignore cells with NA? i had to delete all NAs for it to work.