Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2003

Wed 26 May 2010, 16:39 Delegate Eiman said...

Eiman has attended:
Excel Introduction course

Excel

Do you offer on site training

Fri 28 May 2010, 09:55 Edited on Fri 28 May 2010, 09:56 Trainer Jacob said...

RE: excel

Hi Eiman

Thanks for your forum post.

Yes we do offer onsite training across the UK. We can deliver Professional & Management, Microsoft Office training one to one or groups, standard, tailored or even bespoke content based on your very own working files.

If you would like to generate a quotation, you can do this in just 60 seconds, click here.

If you have any further questions please let us know.

Kind regards

Jacob

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Excel

Excel

RE: excel

Excel articles

Excel tip:

Sum Up All the Values in A Column