Summing number formatted visible data only

M

mondo

I have a list of numbers that are formatted to display 1 decimal place
(but have values with more than 1 decimal place) and i want the sum
function to add the visible value. Short of this formula
=round(a1,1)+round(b1,1) is there a way to sum the values as
displayed? (I thought of nesting round within sum but couldn't get it
to work across a range)

Thanks
 

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

Excel does not accept text format! 0
Use TODAY() function as the criteria in a SUMIF formula 1
Mail Merge - displaying a conditional number of decimals 5
Sum Function has small remainder 2
office 2003 Excel - SUM 3
Total is off by a couple of cents 4
the decimals extends after the sum function 2
VBA multiple list of values for variable 1

Top