B
_Bigred
Hello All,
(Excel 2000)
If I have a sheet and use auto filter, I will would like to be able sum,
average etc... it's results without fixing the cell range(s) every time I
change the autofilter "criteria".
e.g. Column N is classification - I select "Correctional Officer" it
returns just correctional officers. then want to sum Column U's results
which are hourly pay.
First record is Row 269 (but each records retains it's original row #, from
before the autofilter). And If I select a different classification it would
return the original row #'s for the records being filtered etc..
How do I create a sheet that sums =SUM(2003Frozen!U?:U?) to sum just
the results of the autofilter??
TIA,
_Bigred
(Excel 2000)
If I have a sheet and use auto filter, I will would like to be able sum,
average etc... it's results without fixing the cell range(s) every time I
change the autofilter "criteria".
e.g. Column N is classification - I select "Correctional Officer" it
returns just correctional officers. then want to sum Column U's results
which are hourly pay.
First record is Row 269 (but each records retains it's original row #, from
before the autofilter). And If I select a different classification it would
return the original row #'s for the records being filtered etc..
How do I create a sheet that sums =SUM(2003Frozen!U?:U?) to sum just
the results of the autofilter??
TIA,
_Bigred