I spent ages browsing the net to no avail.
I'm trying to get this to work:
=SUM('Permit 17-18'!C49:ADDRESS(39,COUNT(C49:N49),4)) but Excel doesn't like it.
Address bit is basically E49. How on earth do I get Excel to accept E49 so it processes: =SUM('Permit 17-18'!C49:E49)