Posted to microsoft.public.excel.worksheet.functions

Curtis

external usenet poster

Posts: 181

Sumproduct I think but a tough one

Thx alot

"barry houdini" wrote:

Are B10:B129 all different? If so you could use

=INDEX('Source'!D$10:Q$129,MATCH(J1,'Source'!B$10: B$129,0),MATCH(B
$3,'Source'!D$8:Q$8,0))

regards, barry

or if there might be multiple matches in column B

=SUMIF('Source'!B$10:B$129,J1,INDEX('Source'!D$10: Q$129,0,MATCH(B
$3,'Source'!D$8:Q$8,0)))

regards, barry
.

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
Please help. This is way too tough for me.	Champ	Excel Discussion (Misc queries)	2	November 24th 08 02:58 PM
Tough one	Ben	Excel Discussion (Misc queries)	3	December 11th 06 05:13 PM
Tough one:	Imba	Excel Discussion (Misc queries)	7	November 15th 06 08:19 PM
Tough: Vlookup, Match, Sumproduct? To create list of persistence	SteveC	Excel Discussion (Misc queries)	1	June 5th 06 03:34 PM
Tough one...	Peter1999	Excel Discussion (Misc queries)	4	May 2nd 06 11:18 AM

All times are GMT +1. The time now is 07:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us