BlackMagic
New Member
- Joined
- Sep 17, 2014
- Messages
- 2
Hello I am trying to average a list of Pricing of a particular product and a specified date. I know how to get the dates but I without each cell referencing the product (just the top row) I can't figure out how to pull the averages.
<tbody>
</tbody> Taking this I want to average off of the Product code EX: LCBR and then the date range I'm seeking as well. This data goes back about 10 years I only put a portion of it here to give an example. Please help!
Blue Shirt | Red Shirt | Grey Shirt | Black Shirt | |
Date | LCBR | LCBS | LCBT | LCBU |
9/1/2014 | 200 | 260 | 250 | 360 |
9/8/2014 | 250 | 245 | 260 | 355 |
9/15/2014 | 225 | 230 | 255 | 350 |
9/22/2014 | 230 | 250 | 300 | 330 |
<tbody>
</tbody>