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

  • Thread starter Thread starter Paul D
  • Start date Start date
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)),,))))
 
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
 
Back
Top