Thanks Max, unless I did it wrong it didn't work. I'm trying to select ALL
of Column C but even when I try to do that or just select the column it
doesn't work. :(

"Max" wrote:

.. "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
---