I need help with an advanced formula

Microsoft Office excel 2007 plain & simp...
January 25, 2011 at 13:19:23
Specs: Windows Vista
I have a register file in Excel with thousands of rows. For example, Col A=Date, Col B=Payee, Col C=Amount. The same payees appear many times on different dates and different amounts. The entries are in Date order. Can I have a formula to give me a Running Total in Column D by Payee? This means that, for example if I am in row 250, that it should find all payees with the same name above the row in which I am and give me a total for that particular Payee. I need a formula that as soon as I add another Payee it should search all above entries with that particular name and give me a total until that particular row and then continue as I continue with upddated amounts of running totals as I continue with my entries. Any questions or advice, please contact me at: xxxxx@xxxx.com - Thank you

edited by moderator: email address deleted

See More: I need help with an advanced formula

Report •

January 25, 2011 at 14:10:20

Past the following formula in cell D2 assuming you have your other columns arranged as described in your post with headers in the first row and data beginning in the second:

Report •

January 25, 2011 at 16:10:42
You should never post your email address in an open forum.

It's not that we care whether or not you get a bunch a spam, but we don't want to be known as a site where email addresses can be harvested.

That kind of reputation opens us up to all sorts of security issues.

I have deleted your email from your post.

Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question