Thanks for the reply

1) The formula will need to add all values from 3000 to 3199
2) I need a seperate formula to add the values containing a D at the end for eg 3000D, 3001D, 3110D etc