Hello Everybody.
I've been searching for ages for an answer to this but my searches have been fruitless, so I'm going to have to pick the community's brains.
OK is it possible to have a running total in one cell and for example have the following cells added on a certain date? So A1 is added on 02/02/2015 then B2 05/02/2015 and so on.
Any help is much appreciated
Many thanks
Will.
Hi, welcome to the forum
It will probably be easier to offer help if you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
having said that, I have a feeling you need to look at using the sumifS() function for this?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for the help Dibbins, I had an idea it might involve ifs of some sort but i've only really got my teeth into excel recently so I'm not massively ah fait with it yet. Ill roll with this for now as I find you learn better having play around. Ill pop back if i get stuck if thats cool
Once again many thanks
The sumifS() function is useful in that it will add values that fall within certain criteria...
add all a's between march and June
Add all scores from Men aged 20
add all mileages from cars from make = Ford, model = F150, Terrain = Flat
etc
All sorted, thanks alot Dibbins. The key was =TODAY(). Check out the sheet ive attached so you can see what i meant. You can see how i solved it in D1.
Regards
Will.
Nice
1 question though, it looks like your last 2 criteria are the same?
=SUMIFS(B4:B6,
C4:C6,"<=" & $A$1,
C4:C6,"<=" & $A$1)
Was the 2nd (or 1st) supposed to look at a date before (or after) today?
You are quite right its meant to just read
=SUMIFS(B4:B6,C4:C6,"<=" & $A$1)
I'm not quite sure how I managed that
haha ok, been there, done that - it should not have affected the results
You can increase the range of that, by using full columns...
=SUMIFS(B:B,C:C,"<=" & $A$1)
That way, you dont need to adjust it ad the table grows
Ah that's a great tip, wish I'd known that a few weeks ago though. Not sure I'm going to need it when I put this into place as its being but into a pre existing spreadsheet that runs my finances.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks