IF YOU HAVE A + B+ C = X AND YOU FILTER SO ONLY A IS VISIBLE, HOW DO YOU GET X TO ONLY EQUAL A?
S SWMARINE Aug 5, 2004 #1 IF YOU HAVE A + B+ C = X AND YOU FILTER SO ONLY A IS VISIBLE, HOW DO YOU GET X TO ONLY EQUAL A?
J JE McGimpsey Aug 5, 2004 #2 I suspect you can use SUBTOTAL(), but you really don't give enough detail to do more than guess...