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?






[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]1/31/18[/TD]
[TD]2/28/18[/TD]
[TD]3/31/18[/TD]
[TD]4/30/18[/TD]
[TD]5/31/18[/TD]
[/TR]
[TR]
[TD]505 - -*1111[/TD]
[TD]Account 1[/TD]
[TD]1935.40[/TD]
[TD]2391.30[/TD]
[TD]2666.16[/TD]
[TD]2809.15[/TD]
[TD]2813.04[/TD]
[/TR]
[TR]
[TD]505 - -*1212[/TD]
[TD]Account 2[/TD]
[TD]168.44[/TD]
[TD]168.44[/TD]
[TD]168.44[/TD]
[TD]168.44[/TD]
[TD]168.44[/TD]
[/TR]
[TR]
[TD]505 - -*1414[/TD]
[TD]Account 3[/TD]
[TD]222.90[/TD]
[TD]222.90[/TD]
[TD]222.90[/TD]
[TD]222.90[/TD]
[TD]222.90[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/18[/TD]
[TD]MTD Budget[/TD]
[TD]YTD Budget[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]505 - -*1111[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.