Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add content of hyperlink cells
I need to sum up the content (numbers) of hyperlink cells. When I used Sum,
it returns 0 despite figures in the cells. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add content of hyperlink cells
mine add as numbers.
yours may look like numbers but they might be text make a copy of your workbook and try things like = A1 +A2 see what you get if zero =value(A1)+Value(A2) if still zero =value(trim(clean(A1)))+value(trim(clean(A2))) If still zero you probably have non printing charaters which you will have to identify to remove before you can add them "Mort" wrote: I need to sum up the content (numbers) of hyperlink cells. When I used Sum, it returns 0 despite figures in the cells. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge content of cells | Excel Worksheet Functions | |||
hyperlink from pivot table content | Excel Discussion (Misc queries) | |||
Clear Cells Content | Excel Discussion (Misc queries) | |||
Remove content of last visited pages in "Insert Hyperlink" dialog | Excel Worksheet Functions | |||
How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) |