I'm always so pleased when I find a way round some exasperating computer problem that I thought I'd share my moments of triumph ...

Monday 12 December 2011

Word for Mac 2011: sum table cells including blanks

Whoo, another Cracked-it moment!

Word 2011 for Mac - just acclimatising. At last an improvement on the previous version, except Help seems non-existent, even online. Whatever happened to the manual?

In a table, how to sum a column (or row) of figures that contains blank cells? AutoSum only adds up the immediate filled cells.

Put the cursor in the table cell where you want the total.
Top menu bar, go to Insert, then Field.
Type your required range in, e.g. =SUM(C1:C10).
Press return, and voila!

Field can be one of several useful items including word count, total etc.
Only snag is, the Field doesn't update automatically. To update it place the cursor in the field and right click - from the pull down menu, an option is Update field.