Hi, I am trying to automate a spreadsheet to calculate gross sales for each month, the are multiple brands I need to include that are on different rows. The months go by column so the range includes multiple columns which is why I think I am getting an error. The formula I am currently using is =SUMIFS('PL Updated'!$BT$8:$CI$28,'PL Updated'!$BT$7:$CI$7,$D$1). D1 refers to a cell with the month, so I was hoping that each month I could just put the new month into this cell and then the SUM would draw from the next column on the sheet with the sales. Do I need to use a different formula or an array? Thank you in advance!