Let me start with an apology for leaving it so long without a post. It's been a busy time work-wise and, in addition, I've taken ...

Regular readers and clients will know that I'm a big fan of PivotTables. If you format your data into a table format, you can creat...

I have covered both SUMIFS and COUNTIFS in earlier posts. To recap: You can use COUNTIFS to count the instances of a value in a ra...

In this post I want to touch on a topic that I've not written a lot about on this blog - printing. There are many settings in Excel...