Excel Question / Formula Needed

[timbo343]

Hi All

Im after a massive favour. I need to create a spreadsheet with a running total but only to today's date. Please see the attachment. All the instructions are in there.

Thanks

Tim

[Michael]

The file is corrupt...

[EduTech]

Yh file is corrupt (no files to extract)

James.

[kmount]

Works fine for me, just can't do what he wants

[kmount]

Have uploaded it again to see if you guys can open mine.

[EduTech]

Gharr! now ur one is corrupt lol. whats going on

[kmount]

Weird ...

Only thing different between us is that I'm on linux.


EDIT: Try just renaming this one to xls from .zip.

[EduTech]

Nope dont work.. it dont want me to help you lol sorry :P

[EduTech]

Yay! works now.. Stoopid IE 8

I am uninstalling that peice of crap right now! only lasted 3hrs and amount of problems unbelivable bloody M$

Works with FF

James.

[EduTech]

Ignore me i never read it right

[timbo343]

lol, seems like you guys are having trouble even before you have a look at the problem. I can see it been a very complex formula

Thanks

[timbo343]

Updated: File Attachment

Hopefully this one isnt corrupt!

EDIT: I cant upload a stable version. They are all corrupt when they are uploaded.

Ok I have uploaded a screen shot, hope it makes it a bit more clear

Thanks

[kmount]

I don't know what's up because it works fine for me

Screenie attached.

[EduTech]

for all you windows users, i think there is an issue with IE

If you use FF it works sound well did for me anyhow.

James.

[dhicks]

I need to create a spreadsheet with a running total but only to today's date.

You can do this with an IF formula in the columns to the right of the numbers you're typing in. If the given date is less than or equal to the current date (given by NOW()) then result is the value in the cell (or the negative of it, if you're looking at the "out" value), otherwise 0. I.e in F9 put:

=IF(A9<NOW(),C9,0)

And if F10 put:

=IF(A10<NOW(),-C10,0)

Make sure you start off with the correct total - in F6 put:

=C6

And in C4, calculate your total:

=SUM(F6:F52)

Adjust the formula for columns G and H. Hide them afterwards if you want.

--
David Hicks