Add content of hyperlink cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

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

Can UDF return a customized hyperlink? 3
Excel How to add numbers in same cell? 2
Excel formula, sum the value cell and if empty cell left blank 0
VLOOKUP return cell location and hyperlink 0
How do I drag a hyperlink series to fill instead of copy? 2
testing range of cells for part of cell content 5
Despite formula I use (for example SUM) result is always zero. 4
VLOOKUP referencing a cell with a URL 1

Back
Top