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

If you found this blog useful, why not give it a share?

Facebook
Twitter
LinkedIn
Pinterest
Reddit
Email
Print

Leave a Reply

Your email address will not be published. Required fields are marked *

four × 2 =