It’s been busy!

Sorry for the lack of posts here – it’s been busy during the day, though I’ve had time I should have used to post here in the evenings, which instead I spent reading facebook and emails – it’s so easy to do isn’t it?! I’ve been reminded though that where VLOOKUP used to be the answer of choice, it’s perhaps now becoming sumproduct. Why? Well, although Microsoft have now introduced sumifs and countifs functions, they are quite tricky to use – and in the same way that & does the same as concatenate, you can use a sneaky trick with sumproduct to do the same as the new functions – and it’s something that works in older versions of Excel too! I think there is probably a need for a video – I’ll set myself a diary note and I’ll produce one for you!!

Leave a Reply