Hello all,
I have Column A with property type and Column B with totals in separate sheet. I am trying to total "Post war parlour 3 bed" and "Pre war parlour 3 bed" to give one total for 3 bed parlours. I have tried:
{=SUMIFS('Pivet Tables'!$B$3:$B$63,'Pivet Tables'!$A$3:$A$63,"Post war...