Adding cell by cell by cell.....

[scubab]

Hi everybody,

I am fairly new to Excel and I've gotten myself stuck. My trouble ha
to do with formulas. I am recording how many times something happens i
a day so my worksheet goes as so: column A=Day of the week, B=date, C
the number of times it has happened, and E=comments. Notice D i
missing? I want column D to equal the total number of times the even
recorded in C has happened thus far. Let's say Saturday Aug. 5th i
happened 3 times, D2 should equal 3. On Sunday Aug. 6th it happened
times, so D3 should equal 6 and so on. This will be something on goin
for many weeks so I would like a formula with infinite reach in colum
D. I've been told that this task would require a macro...I don't have
clue how to use macros. If I haven't explained myself well enough, I ca
post a screenshot if needed! I guess I can ask something else, too
while I'm in a posting mood: How can I have looked titles? By this
mean if I want Column A to be titled Day of the week, I want to be abl
to scroll to all the way down to row 50+ and still see that column A'
title. Sorry this is so lengthy and needy

Please and thanks in advance!!!!:

 

[Biff]

Hi!

Try this:

Assume row 1 is your column headers. The data starts in row 2.

Enter this formula in D2 and copy down to as many rows as you think you'll
be using:

=IF(C2="","",SUM(D1,C2))

This assumes that you won't have any empty rows within your data set.

How can I have looked titles?

If your headers are in row 1 select cell A2.

Goto the menu Window>Freeze Panes

Biff

 

[scubab]

Thank you so much Biff. Your advice helped me %100 :

 

[Biff]

You're welcome. Thanks for the feedback!

Biff