tly0227
New Member
- Joined
- Oct 2, 2012
- Messages
- 37
I'm currently going through a data analysis tech bootcamp and am struggling trying to figure out a formula. There's an easier way to get the result I want, but my advisor is encouraging me to figure it out via a formula.
Sheet 1) WTRT
Sheet 2) EMA
Need a formula that first finds the total cost for each purchase (WTRT B1*C1) and then averages it for each month. The first month # reference is cell C$14 on this sheet. I'm well aware that I could just make a new column and get the totals, and then do an averageifs from there and it'd be a lot easier...but that idea has been nixed.
Is it possible to do this? Can someone please point me in the right direction? I've been messing around with it for a while and am getting nowhere good.
Sheet 1) WTRT
B: # of units | C: Price per Unit | D: Month # |
2674.43 | 89.33 | 1 |
2576.13 | 61.95 | 1 |
2131.98 | 45.90 | 2 |
2772.06 | 80.86 | 5 |
2143.49 | 55.96 | 6 |
Sheet 2) EMA
Need a formula that first finds the total cost for each purchase (WTRT B1*C1) and then averages it for each month. The first month # reference is cell C$14 on this sheet. I'm well aware that I could just make a new column and get the totals, and then do an averageifs from there and it'd be a lot easier...but that idea has been nixed.
Is it possible to do this? Can someone please point me in the right direction? I've been messing around with it for a while and am getting nowhere good.