I have a large table in which I used formulas to look up data on a different tab. The header row contains a filter so I can check/uncheck the data I want to see by month. I am trying to count the number of total comments entered each month. For example:
Date Comment Order# January 1, 2017 Index/match formula returns a comment associated with this order # abc123 February 4, 2017 index/match formula returns a comment associated with this order # cdf345 February 25, 2017 index/match formula returns a comment associated with this order # def678 March 5, 2017 index/match formula returns blank cell because there was no comment entered with this order # fgh789
In using =COUNTIF(B2:B5000,"?*"), I get the right total number of comments (3). However, if I want to filter by only February, I'd like it to update to 2 since there were only 2 comments entered in that month. How can I create a formula that generates the subtotal of visible cells, but exclude anything with a formula that returns a blank cell?
Bookmarks