Have attached a sample spreadsheet. What I would like to be able to do is to ues the subtotal function but in Column D have the subtotal row show the count of the number of rows that have "Match" Needless to say the sheet does other functions and uses vlookup to get to the point of what I am trying to do. Bottom line question - is it possible to use the subtotal function on Column D and have it only count if the cell has the specific value for each subtotal - as I said in the original, it is a rather large spreadsheet and will have over 750 subtotal rows.
Bookmarks