| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for different array
Thank you, Jacob. It works.
"Jacob Skaria" wrote: Try =SUMPRODUCT(SUMIF(A:A,C1:C100,B:B)) If this post helps click Yes --------------- Jacob Skaria "John" wrote: Hi Jacob, Thank you for the quick answer however this is what I want. I want be able to write like: SUMIF(A:A, C:C, B:B) - Meaning: Sum If one of the value in range A:A equal to one of the value in range C:C then Sum B:B. So instead of C1 in your formula, I want to be able to put the range C:C "=SUMIF(A:A,C1,B:B)" Thank you John "Jacob Skaria" wrote: =SUMIF(A:A,"agb",B:B) OR =SUMIF(A:A,C1,B:B) If this post helps click Yes --------------- Jacob Skaria "John" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function for an array | Excel Worksheet Functions | |||
| Array / Function HELP!!! | Excel Worksheet Functions | |||
| OR function in array-entered IF function | Excel Worksheet Functions | |||
| need some help with an array function | Excel Discussion (Misc queries) | |||
| array function | Excel Discussion (Misc queries) | |||
Threaded Mode
