Tech Tip: Excel and Subtotals

clive All, Excel, Tech Tip

If you use SUM() in Excel to calculate totals, you may want to know about the SUBTOTAL() function, which does a similar job, butbetter. SUBTOTAL takes 2 arguments – the first is a ‘magic number’, that tells it what you want to do; the second is a range of data to be totalled. Here’s what the magic numbers do: 1 …

Rectangle Red are Hiring (Stony Stratford, Milton Keynes)

clive ASP.Net, Jobs, Milton Keynes, Rectangle Red, Stony Stratford, VB.Net

We’re expanding and looking to hire a junior and a senior application developer! You’ll need experience and skill with Microsoft technologies (.NET in particular), relational database systems (e.g. SQL Server or MySQL), and to be a dab hand with the latest web technologies (HTML5, CSS3, JQuery, etc). We offer all you would expect – a competitve salary, opportunty to learn …