How do you do....it? Thread, Excel Question / Formula Needed in Technical; As for actual problem, there are two possible solutions. You could enter the out figure with a minus then you ...
4th August 2008, 08:02 PM #16
- Rep Power
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.
Last edited by m2d2; 4th August 2008 at 08:04 PM.
Thanks to m2d2 from:
timbo343 (4th August 2008)
4th August 2008, 08:09 PM #17
Originally Posted by dhicks
4th August 2008, 08:15 PM #18
Give that man a cookie, he makes it sound simple.
4th August 2008, 08:36 PM #19
4th August 2008, 09:00 PM #20
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).
Originally Posted by m2d2
4th August 2008, 09:22 PM #21
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?
4th August 2008, 09:29 PM #22
Interesting.. What browser are you using?
4th August 2008, 10:06 PM #23
Make a post in Site problems instead of us sorting it our here
By sqdge in forum Office Software
Last Post: 10th February 2013, 07:18 AM
By russdev in forum Office Software
Last Post: 9th May 2008, 12:51 PM
By vunsev in forum Coding
Last Post: 11th April 2008, 09:08 AM
By DSapseid in forum Windows
Last Post: 7th November 2007, 05:56 PM
By oyoung in forum Windows
Last Post: 30th March 2007, 11:27 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)