Sumif-index-match

[kredstone]

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?

		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>

 

[Marcelo Branco]

Welcome to Mr Excel forum

Try
=SUMIF(C$1:G$1,"<="&A$6,INDEX(C$2:G$4,MATCH(A7,A$2:A$4,0),0))

Hope this helps

M.

 

[kredstone]

Thank you! That worked!!!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.