Adding cell values based on what you see

J

Jeff Jacobson

Change your formula that rounds the numbers to =VALUE(ROUND
(A1,0)). Then simply sum these values. If you do not
have a formula rounding these numbers, just add a formula
=VALUE(A1) referencing each rounded value. Then sum these
values.
 

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

adding a forumla to cells with formula in them already 1
MS Project. Real progress of the project, % complete 1
Adjusting formulas by copying across cells w/o changing the refere 6
Rounding Existing Formulas/Values 1
Convert inches & display as Feet Inches and Fractions -- BUG FREE 12
subtraction returning incorrect calue 5
Word macro that can call cells out of Excel for a find and replace 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1

Top