alektherussian
New Member
- Joined
- Sep 12, 2014
- Messages
- 8
Hi there,
I have a problem that I can demonstrate in simplified way as follows:
<tbody>
</tbody>I would like a formula that would first calculate the average over each category (i.e., A = 350, B = 300, and C = 400) and then take the average of the three amounts (i.e., 350). The key is I would like this to be done with a formula(I believe it would have to be some complex array formula) without creating supplemental columns or a PivotTable.
Is this at all possible? Or is writing a custom VBA formula the only option?
Thank you all for you help!
-Alex
I have a problem that I can demonstrate in simplified way as follows:
Company | Amount |
A | 500 |
B | 200 |
C | 400 |
A | 200 |
B | 400 |
<tbody>
</tbody>
Is this at all possible? Or is writing a custom VBA formula the only option?
Thank you all for you help!
-Alex