.. "PRO!$C$2:$C$1400"
.. I can't get in to fix this to make it say like 10,400.

One guess is that it is a multi-cell array formula. Click on any formula
cell within the range, press CTRL + "/" key to select the full extent of the
range. Edit it to the new range within the formula bar, then press
CTRL+SHIFT+ENTER to re-confirm it.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---