Calculation with specific data from field.
I have a field called status that contains - nominated, nominating, awarded and judged. Some records contain blank cell but other contain 1 from each of the 4 mentioned.
I need to create a field for each that will display the number from: nominated, nominating, awarded and judged - so I can display the total number from each on a layout.
Any help with this would be greatly appreciated.