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
 
You must log in or register to reply here.

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
testing range of cells for part of cell content 5
How do I drag a hyperlink series to fill instead of copy? 2
Despite formula I use (for example SUM) result is always zero. 4
VLOOKUP referencing a cell with a URL 1

Back
Top