moderated Re: MS EXCEL formula


george b <gbmagoo@...>
 

Here you go

If you just wish to add the cells in a collum do the following;

Example =SUM(D1:D14)

You would put this formulia in d 15
So now the first cell in the formulia is the one you wish to start with and
the last cell in the formulia is the last cell you wish to add together and
that would be in celld15 where you put the formulia

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Rick Mladek
Sent: January 13, 2020 5:48
To: main@jfw.groups.io
Subject: Re: MS EXCEL formula

Hi Ann, maybe I need more coffee as well. I'm lost and I must admit... can
you give me the formulas and steps for columns D and E with the starting
line of information/numbers being row 14 with row 13 blank.

Thank you and I am sorry...

Rick

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Monday, January 13, 2020 7:33 AM
To: main@jfw.groups.io
Subject: Re: MS EXCEL formula

Hi, Rick,

Assuming the following formula in E14:
=e13+d14.
E13 should have your beginning balance, which would be 0 (Excel assumes a
blank is 0).
D14 should have the first number you want to add to the beginning balance,
e.g. 10.
So. the number in e14 (e13+d14) should be 10.
Copying/pasting the formula into f15, it should read =e14+D15.
So. E14 is 10, as calculated above; +d15 which is the next number you are
adding, say 32. E15 should equal 42.
And it carries on down, incrementing as you go.

Make sense? Only one cup of coffee so far, so if it doesn't I will drink
more and try to explain it better.

Join main@jfw.groups.io to automatically receive all group messages.