Forum Discussion
Relative reference not changing with array formula
Bit of a beginner but I have an array formula: =SUM((BudgetedBaseShiftsALL!$C3:$C$2044 = Hours2!$A3)*(BudgetedBaseShiftsALL!$D$3:$D$2044 = "CC Total Hours")*(BudgetedBaseShiftsALL!$A$3:$A$2044 = ...
Sorted
Just in case, it's better to use SUMIFS for better performance or at least SUMPRODUCT to avoid array formula