Forum Discussion
request Excel formula help counting only the visible cells when using a filter
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 c...
Thank you Hans, this works when using a filter but the data table I exported must have a hidden format because the blank cells are also being counted, which is why I was trying to only count cells with a value >0. Might you know a workaround to not count the blank cells which are not hidden? When I delete a blank cell, your formula updates to one number lower, so the formula works. I just now need to figure out how to either format my data spreadsheet differently or come up with a formula workaround. Thank you
- OMG, yes it does work!! Thank you so much Hans. I can't tell you how many hours I've spent trying to make this work.
I tried formatting the blank cells to zero, but that didn't work either. Thank you!!