I guess it really depends what you are doing, and what you are hoping to achieve. One option is to set the Count column to simply equal the primary key, but this seems pointless... Another would be to query the Max value of the primary key (or the sum, count of records etc) and add one.
What are you trying to accomplish?
In relation to your further information, you could use a query like this:
select count(*) from TABLENAME where State=@P_STATENAME
This will give you the number that already exist. Save this in a variable and add one. ;-)