Posted to microsoft.public.excel.worksheet.functions

Balan

external usenet poster

Posts: 70

sumproduct

I want the weighted average of selected items in an array. The items should
be identifiable by a criteria. For example if column A5:A12 has characters
A,B,A,C,A,D,E,E and columns B5:B12 and C5:C12 have some values , I want the
weighted average of columns B and C using A as the criteria. How to do it ?

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
sumproduct	Rex	Excel Discussion (Misc queries)	5	October 9th 06 08:49 PM
Sumproduct help	David	Excel Worksheet Functions	3	October 8th 06 02:45 AM
SUMPRODUCT Help	xlcharlie	Excel Worksheet Functions	4	October 6th 06 03:12 PM
how to use sumproduct	alias abuhasan	Excel Worksheet Functions	1	November 15th 05 03:45 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us