SUM Not Working

  • Thread starter Thread starter inveni0
  • Start date Start date
I

inveni0

I have a column of numbers (currency). I have formatted it to Currenc
type. However, when I run a =SUM(H:H) formula (in a separate column
of course) it returns only the value of the last field. If I ru
=SUM(H1:H7) as a test, it returns "0".

Any ideas
 
It appears to be a format problem! Is there a way to strip the $ sig
out of a cell and place the result in another cell
 
Solved it. The data I was importing had extra spaces...I had to do
find/replace...fixed 'er right up
 
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

Offset, Match Questiond 5
Excel formula, sum the value cell and if empty cell left blank 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Summing filtered rows with 2 conditions 2
Sum of minutes and seconds times price? 2
Minus Zero 11
How to set cell value to emptry if three other columns are empty too 1
Formula using "If" and "or" criteria. 1

Back
Top