stevenkoo252
New Member
- Joined
- Dec 17, 2015
- Messages
- 4
I currently have monthly data from 2013 to 2015 as shown below.
<colgroup><col><col span="10"><col span="3"><col><col><col><col span="17"></colgroup><tbody>
</tbody>
Now, I tried to use sumif or somproduct before using index match function but I am not getting the return value i was hoping for... I could easily just use =sum() but wanted to know if there is any way.......
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
Please advise. Thanks,
2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2014 | 2014 | 2014 | 2014 | 2014 | 2014 | 2014 | 2014 | 2014 | 2014 | 2014 | 2014 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | |
Jan-2013 | Feb-2013 | Mar-2013 | Apr-2013 | May-2013 | June-2013 | July-2013 | Aug-2013 | Sep-2013 | Oct-2013 | Nov-2013 | Dec-2013 | Jan-2014 | Feb-2014 | Mar-2014 | Apr-2014 | May-2014 | June-2014 | July-2014 | Aug-2014 | Sep-2014 | Oct-2014 | Nov-2014 | Dec-2014 | Jan-2015 | Feb-2015 | Mar-2015 | Apr-2015 | May-2015 | June-2015 | July-2015 | Aug-2015 | Sep-2015 | |
Alpha | $6M | $6M | $6M | $5M | $6M | $6M | $6M | $6M | $7M | $7M | $8M | $7M | $7M | $7M | $7M | $6M | $7M | $7M | $8M | $7M | $7M | $8M | $8M | $8M | $8M | $8M | $8M | $8M | $8M | $8M | $9M | $9M | $8M |
Romeo | $1M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M |
Bravo | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $1M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $2M | $1M | $2M | $1M |
Total | $9M | $9M | $9M | $9M | $9M | $9M | $9M | $9M | $10M | $10M | $11M | $10M | $10M | $10M | $10M | $10M | $11M | $11M | $11M | $10M | $11M | $11M | $11M | $12M | $11M | $11M | $11M | $11M | $11M | $12M | $12M | $12M | $11M |
<colgroup><col><col span="10"><col span="3"><col><col><col><col span="17"></colgroup><tbody>
</tbody>
Now, I tried to use sumif or somproduct before using index match function but I am not getting the return value i was hoping for... I could easily just use =sum() but wanted to know if there is any way.......
2013 | 2014 | 2015 | |
Alpha | |||
Romeo | |||
Bravo |
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
Please advise. Thanks,