Expert: Richard Alcindor - 9/9/2008

Question
Hi, Richard,

I’m having trouble creating a “total to date” column when there are several negative numbers within the column.

Also, I’m having no luck at all with a “Difference” column.   The difference between “today figure & yesterday figure” particularly when negative numbers occur.

If permissible, I can sent my little spreadsheet as an attachment if that would help.  It's only a few rows and columns.  

Thank you very much.

Frank  

Answer
Frank:
Sorry for the late answers, I was sick the last few days.  send me the spreadsheet and I'll put the answers on it for you.  From what I gather from your current info:

=sum(a1:d1)
where a1 is the beginning address and D1 is the end address of the column you're trying to sum up.  change the cell address to fit your circumstance.   

in terms of the difference formula, try this:
=sum(a1:a4)- sum(b1:b4)
where a1:a4 is the sum of the "today figure" and b1:b4 is the "yesterday figure".change the cell addresses to fit your circumstance.   


Please let me know if this answered your question.  If not, like I mentioned before, please send me the spreadsheet and I'll solve and send back the appropriate answers.
Cheers,
Richard