Hogville Info
• 9,620,502 Posts
• 391,981 Topics
• 22,134 Hogvillians
THE RULES (Read 'em!)
Quick Links
Pick'Ems:Football      Basketball      Baseball
Sister Sites:Gridiron HistoryFearless Friday
Listen NOW:Game ON 103.3 
  
Pages: [1]   Go Down

Author Topic: Excel users?  (Read 179 times)

0 Members and 1 Guest are viewing this topic.

longtimeHogfan

  • All-American Hogvillian
  • *******
  • Karma: +469/-350
  • Offline Offline
  • Posts: 3,952
Excel users?
« on: January 30, 2018, 09:29:00 am »

I'm sorry, I didn't know where to properly post my question....I just decided to try here.

If you're an excel user, I need a formula.  I want numbers entered in each cell of a column to automatically add (sum) to the corresponding cell in the next column. 

If column F started out with 500 and I add 100 to column E I want column F to automatically update to 600 to show the running sum.  Should be easy and probably is if you know how....

P.S.  and I want the entire columns, cells 1 thru 500+ to have the same formula.
 
Logged

Russ22

  • Senior
  • *****
  • Karma: +64/-235
  • Online Online
  • Gender: Male
  • Posts: 872
    • Arkansas 7-on-7 Fooball
Re: Excel users?
« Reply #1 on: January 30, 2018, 10:00:20 am »

I do a lot of stuff with Excel, and this should be pretty simple. Let me try to restate what you are asking to do.

I have a column of results in "Column F." I am going to add the each value in "Column E" to "Column F".

If this is what you intend, I think you need to add a third column because this could become an issue with circular references.

If you can add a 3rd column (Column G), then in cell G1 you will want this formula:

=F1+E1

Changing either F1 or E1 will automatically update G1. Then you simply "Fill Down" to the bottom of your data list.
Logged

Sponsored Ad



Hogville encourages you to do business with the following...

HawgWild

  • All-American Hogvillian
  • *******
  • Karma: +257/-217
  • Offline Offline
  • Gender: Male
  • Posts: 4,819
  • Left lane, hammer down.
Re: Excel users?
« Reply #2 on: January 30, 2018, 10:01:49 am »

So, you simply want column F to mirror the amount in the corresponding cell in column E? Your formula in F1 would be "=E1", then drag that formula down the column.
Logged

longtimeHogfan

  • All-American Hogvillian
  • *******
  • Karma: +469/-350
  • Offline Offline
  • Posts: 3,952
Re: Excel users?
« Reply #3 on: January 30, 2018, 10:32:31 am »

Thanks for your replys.

I can add as many columns as necessary.  What I want is something like a checkbook ledger.  Monthly pay at the top of column F for example.  Then periodic cash register inputs throughout the day in column E.  Each one adding to and updating F through several cells.

I'll also need column D to subtract from F as expenditures occur throughout the day through numerous cells.  Make sense?
Logged

HawgWild

  • All-American Hogvillian
  • *******
  • Karma: +257/-217
  • Offline Offline
  • Gender: Male
  • Posts: 4,819
  • Left lane, hammer down.
Re: Excel users?
« Reply #4 on: January 30, 2018, 03:07:25 pm »

If D = Payments and E = Deposit/Credit and F= Balance then your formula for F3 is "=F2+E3-D3" given that row 1 is the header and cell F2 has the starting balance.
Logged

Russ22

  • Senior
  • *****
  • Karma: +64/-235
  • Online Online
  • Gender: Male
  • Posts: 872
    • Arkansas 7-on-7 Fooball
Re: Excel users?
« Reply #5 on: January 30, 2018, 05:15:29 pm »

If D = Payments and E = Deposit/Credit and F= Balance then your formula for F3 is "=F2+E3-D3" given that row 1 is the header and cell F2 has the starting balance.

I would add that you might want to have it as:

"=F2+SUM(E3:E5002)-SUM(D3:D5002)"

This would sum the 5000 entries (mostly 0 when you start) in E and 5000 entries (mostly 0 when you start) in D.

This would maybe keep you running for a while.
Logged

longtimeHogfan

  • All-American Hogvillian
  • *******
  • Karma: +469/-350
  • Offline Offline
  • Posts: 3,952
Re: Excel users?
« Reply #6 on: January 30, 2018, 05:58:54 pm »

Thank you both for your input.  I played around with it and came up with  =sum(F4+E5-D5) and drug it down through 100 cells or so and it worked too.  I've definitely made notes of your suggestions.  Thanks again.....
Logged

Dumb ole famrboy

  • Senior
  • *****
  • Karma: +79/-125
  • Offline Offline
  • Posts: 1,376
  • Your site for Razorback news.
Re: Excel users?
« Reply #7 on: February 02, 2018, 03:30:15 pm »

Start on row 2

Formula for Cell (F2) = (F1) + (E2)

Copy formula to cells (F3) through (F?)

Added comment
If you want to you can put zero or your beginning balance in Cell (F1)
Logged
Pages: [1]   Go Up
 

KARK
KWNA
Fox 16 Arkansas