Using COUNTIF in Summary
I'm looking to create a dashboard. I've got a column in a sheet that has 'Not Started', 'In Progress', 'Complete' as options. I could do with a report that shows 'Not Started' = x and 'In Progress' = y etc.
How do I go about this? Ideally I'd like to put Countif into the Summary rather than update it manually as the statuses could change quite a bit.
Any ideas or other methods as I can't see the wood for the trees at the momemnt...
Help Article Resources
Check out the Formula Handbook template!