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

F

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)),,))))
 
D

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
 
Top