Depends on the type of data you're working with.
Click in the $306 cell and post back with what you see in the formula bar.
Same thing for the $200CR cell.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cbanks" wrote in message
...
I am trying to sum a column.. series goes like this... $306, $200CR,
$500...
I want to add the cells that do not end with CR.. how??
|