A formula for totaling question
I have a sheet that is tracking issues. One column is a category (bug, feature req, UI issue, etc.). The selections are defined in a pull down and isn't free form. I want to create a widget for a dashboard that shows the total number of each category option. It appears I can't do it directly so I thought of building a formula that creates numeric totals on a separate sheet and then charting that. How to I create the formula to run through each row with if this, increment that or some such.
Any thoughts/advice appreciated.
Help Article Resources
Check out the Formula Handbook template!