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.