Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 18

sumproduct

I have a column of ISIN codes and next to it a colum of weights and I want to
add up the weights of only those ISIN codes that start with ES. Lets say one
ISIN code is ES098430202, another one is FR099878324, etc. How would I
construct the function?

Imagine

ES098430202 4%
FR099878324 6%
DE957632458 8%

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
sumproduct? sumif(sumproduct)?	David	Excel Worksheet Functions	3	July 13th 07 07:06 PM
Help with SUMPRODUCT	FrankTimJr	Excel Discussion (Misc queries)	4	October 12th 05 04:27 PM
Sumproduct?	cjjoo	Excel Worksheet Functions	9	October 11th 05 12:31 PM
sumproduct?	cursednomore	Excel Worksheet Functions	2	October 10th 05 08:45 PM
Sumproduct ??	PhilGTI	Excel Worksheet Functions	3	September 22nd 05 05:41 PM

All times are GMT +1. The time now is 01:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us