I need to sum only the values that are visible after i have applied the autofilter.
T Thapelo Nov 2, 2007 #1 I need to sum only the values that are visible after i have applied the autofilter.
D Dave Peterson Nov 2, 2007 #2 Look at =subtotal() in xl's help. I need to sum only the values that are visible after i have applied the autofilter. Click to expand...
Look at =subtotal() in xl's help. I need to sum only the values that are visible after i have applied the autofilter. Click to expand...
P Peo Sjoblom Nov 2, 2007 #3 Look in help for the SUBTOTAL function =SUBTOTAL(9,your_range) -- Regards, Peo Sjoblom
T Thapelo Nov 5, 2007 #4 Thanks Peo. Solved my problem. Peo Sjoblom said: Look in help for the SUBTOTAL function =SUBTOTAL(9,your_range) -- Regards, Peo Sjoblom Click to expand...
Thanks Peo. Solved my problem. Peo Sjoblom said: Look in help for the SUBTOTAL function =SUBTOTAL(9,your_range) -- Regards, Peo Sjoblom Click to expand...
