I'm a novice with Excel. I am using Excel 2002 and want to create a simple
template. I need it to automatically fill in the sum of certain columns and
rows as each cell is filled in. Can someone explain how to do this? Please
reply in plain English, because I will not understand programming language.
If I am posting in the wrong forum, I'd appreciate a suggestion as to where I
should post.

Thank you very much.
--
Susan

One way:

Say you want to sum A1:A10 whenever any cell in that range contains a
numeric value:

=IF(COUNT(A1:A10),SUM(A1:A10),"")

In article <0A1E94D1-64A8-4CDE-B0E8-(E-Mail Removed)>,
Susan <(E-Mail Removed).(donotspam)> wrote:

> I'm a novice with Excel. I am using Excel 2002 and want to create a simple
> template. I need it to automatically fill in the sum of certain columns and
> rows as each cell is filled in. Can someone explain how to do this? Please
> reply in plain English, because I will not understand programming language.
> If I am posting in the wrong forum, I'd appreciate a suggestion as to where I
> should post.
>
> Thank you very much.