In this video I show you how to calculate a location allowance but only when certain conditions are met – the Ref number has to be higher than a certain figure and it’s only paid when the employee is from one of four departments. However it also has to be adjusted to add up the numbers from two columns…. You can download the completed file here.
- Creating a simple accounting system – Part Two – Summarizing your payments
- Creating a simple accounting system – Part One – tracking your payments
- How to summarize multiple CSV files – in minutes
- Summarize same item across multiple worksheets – even if they are in different locations…
- How to use Index Match