Darren Hill

Posts: n/a

On Thu, 08 Sep 2005 00:34:32 +0100, Domenic wrote:

Nice one Harlan! I was going to offer the following...

=SUMPRODUCT(B2:B10,SUBTOTAL(9,OFFSET(C3:C11,ROW(C3 :C11)-ROW(C3),0,ROWS(C3
:C11)-(ROW(C3:C11)-ROW(C3)))))

...confirmed with just ENTER, but I prefer your formula. I'll have to
take a closer look at it so that I can understand it.

I'm doing that, too.
I've saved your formula for study too. Thanks.

Darren

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
Excel option to store trendline's coefficients in cells for use	Miguel Saldana	Charts and Charting in Excel	9	June 20th 05 08:45 PM
help please - trouble with sumproduct function	Jennie	Excel Worksheet Functions	2	June 17th 05 09:40 PM
Help with an array function	malik641	New Users to Excel	4	June 10th 05 05:09 PM
sumproduct function	Andreea Moyes via OfficeKB.com	Excel Worksheet Functions	3	February 24th 05 09:00 AM
Vlookups array function by Alan Beban	falvey3	Excel Worksheet Functions	1	February 17th 05 01:21 PM

All times are GMT +1. The time now is 04:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us