Zdesgain11
New Member
- Joined
- Feb 28, 2019
- Messages
- 4
I currently have a set of data as follows:
<tbody>
</tbody>
I have a dynamic lookup value for the date and want to be able to sum the values that are less than or equal to the month I choose.
For example, If I am looking at A, and want to choose April, I would want to sum April, March, Feb and Jan for a total of 4+3+2+1 = 10.
Does anyone know how to make this possible? I thought about a Sumif Index Match Match formula, but im not sure the best way to set it up.
Jan-18 | Feb-18 | Mar-18 | Apr-18 | Jun-18 | Jul-18 | |
A | 1 | 2 | 3 | 4 | 5 | 6 |
B | 7 | 8 | 9 | 10 | 11 | 12 |
C | 13 | 14 | 15 | 16 | 17 | 18 |
D | 19 | 20 | 21 | 22 | 23 | 24 |
<tbody>
</tbody>
I have a dynamic lookup value for the date and want to be able to sum the values that are less than or equal to the month I choose.
For example, If I am looking at A, and want to choose April, I would want to sum April, March, Feb and Jan for a total of 4+3+2+1 = 10.
Does anyone know how to make this possible? I thought about a Sumif Index Match Match formula, but im not sure the best way to set it up.