I have tried many different ways but can not figure out how to change the following formula to work with a filter.  I want to count cells in row DM if the name in column A matches “sample1″ and the cell is >0, but I need to only count visible cells when using filters on other columns. How do I add the filter criteria?    =COUNTIFS($A$12:$A$400,”sample1″,DM$12:DM$400,”>0″)

​I have tried many different ways but can not figure out how to change the following formula to work with a filter.  I want to count cells in row DM if the name in column A matches “sample1″ and the cell is >0, but I need to only count visible cells when using filters on other columns. How do I add the filter criteria?    =COUNTIFS($A$12:$A$400,”sample1″,DM$12:DM$400,”>0″)  Read More

​