Excel Question / Formula Needed

[m2d2]

As for actual problem, there are two possible solutions. You could enter the out figure with a minus then you would just do a simple SUM to get to the running total.

Alternatively, you could SUMIF so that the value in a particular column is only added to the running total if the word out appears in column B. As an example put the following in cell C4.

=SUMIF(B5:B1000,"=IN",C5:C1000)-SUMIF(B5:B1000,"=OUT",C5:C1000)

[timbo343]

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

THANKS!!!!!

[kmount]

Give that man a cookie, he makes it sound simple.

[m2d2]

@dhicks
I am sorry but using another column is cheating.

I wanted to do the entire formula in one cell but I can't get MATCH() to return correct offset from A5 . I wanted to use this as upper bound of the range of each SUM().

[dhicks]

I am sorry but using another column is cheating

Hmm! It's the sort of thing where you wish Excel's formula language was more capable and could do something like map(array, function).

--
David Hicks

[TechSupp]

Its not a solution to the excel problem just a comment that I have had this problem when downloading zip files etc from edugeek (other sites seem fine). Downloads OK but can't open it as it says it is corrupt?

[kmount]

Interesting.. What browser are you using?

[EduTech]

Make a post in Site problems instead of us sorting it our here

James.