frankee_gee
Board Regular
- Joined
- Mar 3, 2008
- Messages
- 144
- Office Version
- 365
- 2016
- Platform
- Windows
Filtering Date Column "A" 1st qtr 2012<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Column "C" has numbers where we figure the average of the entire column<o></o>
Formula: =AVERAGE(C36:C300)<o></o>
<o> </o>
When I filter or not the Date column "A", the Average is still the same.<o></o>
<o> </o>
How can I force it to only average out the rows displayed by the filter<o></o>
<o> </o>
Thanks for your time.<o></o>
Frankee
<o> </o>
Column "C" has numbers where we figure the average of the entire column<o></o>
Formula: =AVERAGE(C36:C300)<o></o>
<o> </o>
When I filter or not the Date column "A", the Average is still the same.<o></o>
<o> </o>
How can I force it to only average out the rows displayed by the filter<o></o>
<o> </o>
Thanks for your time.<o></o>
Frankee