Filtered COUNTIFS

[raliy2k]

Hi everyone,

I have this formula: =COUNTIFS(Y4:Y61,">=-10.0",Y4:Y61,"<=1.9")/COUNTIFS(A4:A61,"*") Which gives me a percentage.

But it does not work if I use a filter. Am I doing something wrong?

 

[Joe4]

Welcome to the Board!

I think the best thing to do would be for us to try to recreate your scenario to see what might be going on. Can you post a small sample of your data, and show us the filters you are using?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.