Function for different array
This Can be arrived in 2 simple ways.
=SUMIF($A$2:$A$6,$C2,$B$2:$B$6)
OR
=SUMPRODUCT(($A$2:$A$6=$C2)*($B$2:$B$6))
Change the Cell Reference A2:A6 to your desired cell in the above formula,
if required.
If this post helps, Click Yes!
--------------------
(Ms-Exl-Learner)
--------------------
"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
|