Better way? Multiple criteria

[Gman]

Hello

I am wondering if there is a better way to do this. Maybe with VBA? I have a spreadsheet that needs to pull data from a table daily. Currently I am using array formulas but it takes forever and I need to update each array formula manually. So currently I go into each new day array cell push F2 then CSE, control shift enter (is there a different way). The table is on the Summary17 tab and that will grow everyday for the entire year. I need it to find the correct day on the table then return the corresponding result.

Here is my formula currently.
{=IF(OR(Summary17!$A:$A=$A4),ABS(INDEX(Summary17!$E:$E,MATCH(1,($A4=Summary17!$A:$A)*(G$1=Summary17!$B:$B),0))),"")}

Like I said this will grow with each new day and each new month so my plan now is to copy rows A1:O29 and paste below maybe cell A32 for March and so on.

Thank you in advance for the help!

 

[r2c2]

@Gman

Thanks for your question. I am not sure why you are using a complex array formula when SUMIFS could give you same answer.

Try this:

=ABS(SUMIFS(Summary17!E:E,Summary17!$A:$A,'2017'!$A4,Summary17!$B:$B,'2017'!G$1))

Adjust the reference to E:E to F:F for getting the next column values.

 

[Gman]

@Gman

Thanks for your question. I am not sure why you are using a complex array formula when SUMIFS could give you same answer.

Try this:

=ABS(SUMIFS(Summary17!E:E,Summary17!$A:$A,'2017'!$A4,Summary17!$B:$B,'2017'!G$1))

Adjust the reference to E:E to F:F for getting the next column values.

Thank you r2c2. that makes a lot more sense, not sure why I made it more complicated than it had to be. Thank you for the input!