Trying the plug-in. I am trying to get an average YoY increase for each account and an overall "running" average of all accounts. I was thinking sumproduct() would work, but that gets be some crazy numbers. I did a simple average() formula but am not sure if that accurately represents the intended purpose.
Any suggestions??
Any suggestions??
| Book1 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | |||
| 3 | Account | Date | Yrs | Original RFP Amount | Total Additions | Increase | Average YoY | ||||
| 4 | Start | End | |||||||||
| 5 | Act1 | 4/1/2011 | 8.8 | $266,700 | $192,434 | 72.2% | 11% | ||||
| 6 | Act2 | 1/1/2019 | 1.0 | $899,769 | $205,670 | 22.9% | 96.3% | wrong | |||
| 7 | Act3 | $650,000 | $1,132,811 | 174.3% | |||||||
| 8 | Act4 | 3/1/2019 | 0.9 | $351,678 | $- | 0.0% | |||||
| 9 | Act5 | $- | |||||||||
| 10 | Act6 | $- | |||||||||
| 11 | Act7 | 4/1/2017 | 9/2/2019 | 2.4 | $235,440 | $309,677 | 131.5% | 41.3% | |||
| 12 | Act8 | 1/1/2015 | 8/31/2018 | 3.7 | $- | ||||||
| 13 | |||||||||||
| 14 | |||||||||||
| 15 | |||||||||||
| 16 | |||||||||||
| 17 | |||||||||||
| 18 | |||||||||||
| 19 | |||||||||||
| 20 | |||||||||||
| 21 | |||||||||||
| 22 | |||||||||||
| 23 | |||||||||||
| 24 | |||||||||||
| 25 | |||||||||||
| 26 | |||||||||||
| 27 | 3.4 | $2,403,587 | $1,840,592 | 76.6% | 29.8% | ||||||
Averages | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C5:D12, B13:D26, E5:H26 | C5 | =IF(ISBLANK(Overview!C5),"",Overview!C5) |
| I5:I27 | I5 | =IFERROR(((SUM(F5:G5)-F5)/E5)/G5,"") |
| E27 | E27 | =AVERAGE(E5:E26) |
| F27:G27 | F27 | =SUM(F5:F26) |
| H27 | H27 | =IFERROR(G27/F27,"") |
