That very well may be a part of it, but I need the formula to return a range of cells, that is my difficulty --- E3:E19 for example. This range would then go in to a separate formula that would be used to calculate the mode of support case subjects on a per month/quarter/year basis.
How can I use a countifs to return a range? I use that quite often to count cells that contain certain criteria, but never to return a range.
Bookmarks