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 = Hours2!$C$1)*BudgetedBaseShiftsALL!$F$3:$F$2044)
But the Hours2!$A3 is meant to change down the array result column but it puts the reference A3 in every cell?
2 Replies
Sorted
Just in case, it's better to use SUMIFS for better performance or at least SUMPRODUCT to avoid array formula
