use =sumif, with "range" as C column and "sum range" as the numbers and
criteria is the word you want to sum for.

"Dottled" wrote:

I have a spreadsheet and column C has words like suspended, authorised,
pending etc - can I create a formula to total the different states?