View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Using the visible cell information and not the calculated

If you are talking about summing only the Integers of a column of cells, then
something like this will do.........

=INT(SUM(A1:A6))

Vaya con Dios,
Chuck, CABGx3



"G-DEAD" wrote:

I want to add up a list of values that are visible in the column of cells and
not the true calculated amounts.