AutoFilter (SUBTOTAL Formula)
Posted by Jo on January 08, 2002 6:51 AM
I've got 2 columns in question. One is for Weights with a total at the bottom. The other is the Load column. I've got the AutoFilter set on the Load column. I've put the formual =SUBTOTAL(9,G15:G100)
at the end of the weight column. However, it's not working like I thought. I thought it was supposed to show the weight for only what was sorted. When I sort, nothing shows for the total weight. What am I doing wrong?