Tony

Posts: n/a

Sum function not working correctly in Excel (Skips Cell)

I have one cell that is not included in a sum function. This repeats in
several worksheets. e.g. =SUM(C6:C11) Cell C7 is not added in the list.
If I type in the formula =C6+C7+C8+C9+C10+C11 it will give the correct result.

Thanks in Advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
Excel - option to extend function in cell to column	kjoshua777	Excel Worksheet Functions	2	November 18th 04 01:08 AM
Replace function not working properly in Excel 2000 SP3	rgbytg	Excel Worksheet Functions	5	November 11th 04 03:44 PM
Statistical Excel Function Question within Excel 2000...	Drew H	Excel Worksheet Functions	3	October 31st 04 06:55 PM

All times are GMT +1. The time now is 04:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us