Referencing Merged Cells in Formulas - OzGrid Business Applications

I would like help with accessing merged cells using a formula. ... I realise WHY this doesn't work (as Excel refers to the merged cells A3:A5 as just A3, and A4 ...

www.ozgrid.com