There are three posts you should read, in this order, if you're starting out with formulae in Excel.
- Formula fundamentals: this will give you some basic principles that will serve you well
- How to construct formulae in Excel: this will give you the building blocks that will help you actually create formulae
- Using dollars in cell references: it's important to learn this powerful feature early. So what better time than now?
Get in touch if you need any help.

Trouble with formulae? Lookups not going so well? The Wizard of Excel can help. Dan Harrison offers practical tips and examples, as well as Excel training and consulting.