ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using the visible cell information and not the calculated (https://www.excelbanter.com/excel-discussion-misc-queries/75532-using-visible-cell-information-not-calculated.html)

G-DEAD

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

CLR

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.



All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com