But any help would be appreciated.
I have a range of data with irregular dates listed as column headers. For instance
12/27 12/20 12/13 11/29
Apples 1 5 10 32
Bananas 3 7 12 15
Oranges 6 9 32 34
Is there a formula that will allow me to only look at data over a certain date range and by type of fruit?
For instance, say I wanted to compute an average of the number of bananas from 11/29 to 12/20 but it would sitll give me the ability to change my intended dataset to Oranges over 12/20-12/27 if I later wanted that average.
Hope this is clear
I have a range of data with irregular dates listed as column headers. For instance
12/27 12/20 12/13 11/29
Apples 1 5 10 32
Bananas 3 7 12 15
Oranges 6 9 32 34
Is there a formula that will allow me to only look at data over a certain date range and by type of fruit?
For instance, say I wanted to compute an average of the number of bananas from 11/29 to 12/20 but it would sitll give me the ability to change my intended dataset to Oranges over 12/20-12/27 if I later wanted that average.
Hope this is clear