SumIF <=

[kac1125]

Hello I have two Tabs "Data" and "Inbound" I am trying to sum if column A on the "data" Tab is <= Column A in the "Inbound" Tab I am summing Values in Column E on the "Inbound" Tab. The formula I am trying is =SUMIFS(inbound!E:E,Data!A:A,"<="&inbound!A:A) I keep getting the #SPILL! error. Any Ideas on how to fix this? Thanks in advance!

 

[ExcelToDAX]

It is trying to use literally the entire columns. I would change your E:E and A:A to E1:E1000000 and A1:A1000000