I have a sheet with a problem types field , set as drop-down menu, and a value list selected from the field "Problem Types".
The data what i've input can be classificated into 6 types of Prolem.
I want to count how many times these problems appeared, what should I do?
Because of I will chart the number of these problem types in the database.
Many thanks.
Here is another thread about charting, if you want to show "0" for types that have no record.
Return a “0” from an executeSQL Count