Forum Discussion

l3wis.dick's avatar
l3wis.dick
Copper Contributor
Aug 27, 2018

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 = ...
excel
l3wis.dick's avatar
l3wis.dick
Copper Contributor
Aug 27, 2018

Sorted

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 28, 2018

    Just in case, it's better to use SUMIFS for better performance or at least SUMPRODUCT to avoid array formula