Hi all,
How do I modify part of the below formula ‘Doors’!T:T to reference just one cell ‘Doors’!C4
If I change this reference to a single cell I geta #VALUE ! Error rather than the single cell value.
=SUMIFS('Doors'! T:T,'Doors'!$B:$B,'Buildings'!$B42)*(1+$E$2+$G$2)
Steve