Hi Bill,
Thanks for the screen shot. My coding experience is pretty limited so I really appreciate the tips on the syntax. I think I may have had an extra space. However, when I entered the correct formula it crashed. I tried creating a new document with just 3 states (and 3000 cases) and it still crashed when I tried to apply the formula. I am attaching the document with 4 states that I was hoping to apply the formula to (rather than replacing all the 0 by hand!)
Thanks!
Traci