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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match table shading (color) to Visio color/Transparency 1
Newbie Help - IF Yes No Function 0
Recover Outlook calendar entry 1
Calculate the median value before a specified list 0
Excel does not accept text format! 0
Simple IF Statement Help! 3
Cell not calculating after importing data 2
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had 2

Top