Hello,
I'm trying to build a formula that sums up the YTD budget using an account and a date. I got the MTD budget using the following: =INDEX(A1:G4,MATCH(A7,A1:A4,0),MATCH(A6,A1:G1,0))
How do I sum the January through May amounts using 2 variables?
<tbody>
</tbody>
I'm trying to build a formula that sums up the YTD budget using an account and a date. I got the MTD budget using the following: =INDEX(A1:G4,MATCH(A7,A1:A4,0),MATCH(A6,A1:G1,0))
How do I sum the January through May amounts using 2 variables?
1/31/18 | 2/28/18 | 3/31/18 | 4/30/18 | 5/31/18 | ||
505 - -*1111 | Account 1 | 1935.40 | 2391.30 | 2666.16 | 2809.15 | 2813.04 |
505 - -*1212 | Account 2 | 168.44 | 168.44 | 168.44 | 168.44 | 168.44 |
505 - -*1414 | Account 3 | 222.90 | 222.90 | 222.90 | 222.90 | 222.90 |
5/31/18 | MTD Budget | YTD Budget | ||||
505 - -*1111 | ||||||
<tbody>
</tbody>