How to not include hidden cells that is filtered

[jessejames1of3]

I am trying to figure out how to make this formula not include cells that are filtered out.
Any help would be greatly appreciated.

=SUM(IF(ISBLANK(G14:G:G),F14:F:F,0)) ONLY SHOW FILTERED RESULTS

 

[kevin9999]

What is the actual range you're trying to sum?

 

[kevin9999]

I suspect you may just need Subtotal(). Something like:

=Subtotal(9,Range_of_Values_to_Sum)

 

[jessejames1of3]

I suspect you may just need Subtotal(). Something like:

=Subtotal(9,Range_of_Values_to_Sum)

I completely understand and agree. I was just unsure how to while still including the following criteria (IF(ISBLANK(G14:G:G),F14:F:F,0))

 

[kevin9999]

I've no idea what your data layout is, but the following might give you a clue as to which way to go?

Book1
	F	G	H
11		4
12
13	HDR1	HDR2	HDR3
14	data	1	a
15		1	a
16	data	1	a
17		1	a
18		1	a
19		1	b
20	data	1	b
21	data	1	b
Sheet1

Cell Formulas
Range	Formula
G11	G11	=SUMPRODUCT(SUBTOTAL(109,OFFSET(G14,ROW(G14:G21)-ROW(G14),,1)),--(F14:F21=""))

When filtered for "b"

Book1
	F	G	H
10
11		1
12
13	HDR1	HDR2	HDR3
19		1	b
20	data	1	b
21	data	1	b
22
Sheet1

Cell Formulas
Range	Formula
G11	G11	=SUMPRODUCT(SUBTOTAL(109,OFFSET(G14,ROW(G14:G21)-ROW(G14),,1)),--(F14:F21=""))