Creating a KPI Dashboard – Part Three – Preparing our monthly stats

You can view part one of this tutorial here and part two here.

In this tutorial what I want to look at is how to set up formulas to show our monthly stats. We already have our sheets set up and we’ve got a table set up on each one. Next step is to  (a) use group entry to do all of them simultaneously – and at the same time and (b) use Countifs to calculate our entries.  You can view the completed file here