I would like to average a range of numbers if the dates are between 4 weeks ago and today? any ideas.
The dates are in column d12:d100 and the values are in column p12100
any help would be greatly appreciated. Also if I can do this without VBA I would appreciate it beacuse I do not know VBA!
As far as I know there is no averageif function.
_________________
mapakunk
This message was edited by mapakunk on 2002-05-16 09:50
The dates are in column d12:d100 and the values are in column p12100
any help would be greatly appreciated. Also if I can do this without VBA I would appreciate it beacuse I do not know VBA!
As far as I know there is no averageif function.
_________________
mapakunk
This message was edited by mapakunk on 2002-05-16 09:50