Hello
I am using the following sumifs statement and want to know if there is a way to account for one of the criteria changing. Currently I have to go in to each cell and update the criteria.
=SUMIFS('Accrued Expenses'!$H$11:$H$218,'Accrued Expenses'!$A$11:$A$218,"WTCEXT",'Accrued Expenses'!$D$11:$D$218,"605-100-00",'Accrued Expenses'!$C$11:$C$218,153)
If a new line is entered in the Accrued Expense spreadsheet then the numbers will need to be updated for example if a new row is inserted at row 20 then all the rows that come after the number in column C will change and the formula will need to be manually updated.
Thank you
I am using the following sumifs statement and want to know if there is a way to account for one of the criteria changing. Currently I have to go in to each cell and update the criteria.
=SUMIFS('Accrued Expenses'!$H$11:$H$218,'Accrued Expenses'!$A$11:$A$218,"WTCEXT",'Accrued Expenses'!$D$11:$D$218,"605-100-00",'Accrued Expenses'!$C$11:$C$218,153)
If a new line is entered in the Accrued Expense spreadsheet then the numbers will need to be updated for example if a new row is inserted at row 20 then all the rows that come after the number in column C will change and the formula will need to be manually updated.
Thank you