Posted to microsoft.public.excel.worksheet.functions

John

external usenet poster

Posts: 2,069

Function for different array

Hi all,

I need help on writing formula for the problem below:

Column A Column B Column C
CHJ 15 AGB
AGB 10 HHH
JKX 12 NNN
MNB 19 MMM
AGB 20 BBB
. . .
. . .
. . .

I want to be able to write " If one or more value in Column A equal to one
of the value in Column C then Sum column B ". In this case the answer is " 30
", the sum of "AGB".

Thank you
John

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
Function for an array	KatiJ	Excel Worksheet Functions	3	January 23rd 09 04:07 AM
Array / Function HELP!!!	chris[_2_]	Excel Worksheet Functions	2	June 4th 08 08:51 PM
OR function in array-entered IF function	veggies27	Excel Worksheet Functions	8	March 11th 08 06:32 PM
need some help with an array function	Lorin	Excel Discussion (Misc queries)	1	January 3rd 06 02:37 AM
array function	cutsygurl	Excel Discussion (Misc queries)	1	July 1st 05 04:49 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us