PDA

View Full Version : [SOLVED] Sum Up Cells Value When Specific Value Match



epoiezam
05-11-2016, 12:25 AM
Hi Guys:

Need your help.

Sheet1


Customer's Name
No of Engagement


Joe
1


Charles
2


Henry
1


Joe
2



Sheet2


Customer's Name


Joe


Henry




If matched between (Sheet1 - Column A) and (Sheet2 - Column A) the Result will be something like Sheet3 below

Sheet3


Customer's Name
No of Engagement


Joe
3


Henry
1



Thank you in advance guys.

mancubus
05-11-2016, 12:34 AM
Assuming Sheet2!A2 is Joe insert below formula into Sheet2!B2 and copy down.

if argument separator is comma (,)

=SUMIF(Sheet1!A:A,Sheet2!A2,Sheet1!B:B)

if argument separator is semicolon (;)

=SUMIF(Sheet1!A:A;Sheet2!A2;Sheet1!B:B)

epoiezam
05-11-2016, 12:46 AM
Wow that is very interesting. Straight to the point. Thank you mancubus. :)

mancubus
05-11-2016, 01:16 AM
you are welcome.
please mark the thread as solved from "thread tools" dropdown.

take time for self-learning on topics such as basic excel, excel formulas, advanced excel and excel programming.
there are thousands of free stuff on the net.