Using the visible cell information and not the calculated

G

G-DEAD

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

CLR

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
 
Top