Posted to microsoft.public.excel.programming

Phil

external usenet poster

Posts: 1

Summing column w/o VBA. Help.

On Mon, 19 Dec 2005 11:29:42 -0000, Bob Phillips wrote:

You could try

=SUM(OFFSET(B1,MAX(IF(ISBLANK($B$1:$B$65535),0,ROW ($B$1:$B$65535)))-10,0,10,
1))

which is an array formula, so commit with Ctrl-Shift-Enter

Thanks Bob. That works a treat.
Will go off and read up on array formulas now.

cheers

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Summing a column	Rooky228	Excel Worksheet Functions	6	May 14th 09 10:41 PM
Summing a column	Rich D	Excel Discussion (Misc queries)	5	September 4th 07 01:15 PM
summing column c based an column a criteria	ndforty	Excel Worksheet Functions	2	May 3rd 07 06:57 PM
Summing a Column instead of a Column range	SharonP.	Excel Discussion (Misc queries)	1	February 16th 06 07:28 PM
Summing one column based on date in another column	excel guru i'm not	New Users to Excel	7	December 30th 05 08:39 PM

All times are GMT +1. The time now is 10:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us