| total the sum of filtered, formula-based figures |
 Posted by
Christa Williams
on Monday, December 26, 2005 at 7:09:44 PM (EST)
I have column of formula results. I have filtered the worksheet and am seeing the data (from the formulas) on 'screen'. I need a total for values displayed on the page. What can I do to get a total of just this subset of data that appears on the worksheet after I apply the necessary filter. Can someone please help me?
|
 Posted by
Robert Smith
on Thursday, December 29, 2005 at 2:32:34 PM (EST)
Subtotal(9,Startcell:endcell)
Startcell=cell you want to start totaling
endcell=cell you want to end totaling.
|
|
