How do I not Subtotal cells with no value?
Posted by A Miller on September 11, 2001 5:13 AM
I have a column, colunmn 1, that looks to another,column 2. The column 1 formula is - =IF(AG20="1NBBB12011","OK","") meaning that if the second column has certain text then it returns an "OK" if it does not have the exact text, then it returns a blank cell. So I end up with a column that has nothing but "OK"s or blanks. I want to subtotal the "OK"s but whenever I use the subtotal command it also totals the blank cells. The exact subtotal formula that I am using is =SUBTOTAL(3,AA11:AC31). I thought it wouldn't subtotal cells with no value in them but apparently that isn't so. Is there any way to not subtotal the cells that have no values in them. I can't use the COUNTIF command because I am using the autofilter. Thank you very much for your time.