on a filter, I have a column that contains Yes or Now

[Paul D]

I need to add all of the occurances of Yes in the filter?

 

[Frank Kabel]

Hi
if this is in column A try:
=SUMPRODUCT(($A$1:$A$1000="Yes")*(SUBTOTAL(3,OFFSET($A$1,ROW($A$1:$A$10
00)-MIN(ROW($A$1:$A$1000)),,))))

 

[Debra Dalgleish]

You can use the SUBTOTAL function to return results from the visible rows.
For example, if you filter for Yes, and want to add the amounts that are
visible in column E:
=SUBTOTAL(9,E2:E500)

The SUBTOTAL function can summarize the visible data in other ways too.
If you change the formula to: =SUBTOTAL(3,E2:E500)
it will count the visible entries in column E