ExcelBanter - count similar text with using filters

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count similar text with using filters (https://www.excelbanter.com/excel-worksheet-functions/263137-count-similar-text-using-filters.html)

count similar text with using filters

I want to count the number of occourances of a "Y" in coulumn D .. so i used
a countif and it works great however when i filter another column it still
counts all the "Y".

Eduardo

count similar text with using filters

Hi,
try

=SUMPRODUCT(SUBTOTAL(3,OFFSET(d2:d11,ROW(d2:d11)-MIN(ROW(d2:d11)),,1)),
--(d2:d11="Y"))

change range to fit your needs
"mj" wrote:

I want to count the number of occourances of a "Y" in coulumn D .. so i used
a countif and it works great however when i filter another column it still
counts all the "Y".

bala_vb

Quote:

Originally Posted by mj (Post 951325)

I want to count the number of occourances of a "Y" in coulumn D .. so i used
a countif and it works great however when i filter another column it still
counts all the "Y".

Prefer pivot table and use count of Y's. It will show you proper count now even after filter also.

All times are GMT +1. The time now is 11:56 PM.