Sheet Summary - countif
Hi there -
What is the best way to do a 'count' on a drop down field located at the "summary sheet"?
For example: I have a drop down field on summary sheet called "Alignment". It has drop down values such as cost reduction, revenue, risk/fraud. Each sheets has one of those alignment category.
I would like to have a summary report that shows all sheets by alignment count. For example, if I have 13 sheets, it might look like this:
cost reduction 4
I tried doing it on REPORTS, but it's showing a list of all project names (sheet) and it's corresponding
alignment, which is not what I had in mind :(
As always, thank you.