I am new to excel. I think this is a basic question for the experts but i am stuck. Thank you for any help.
I have a column of various names. They are listed in a column B2 down to B6.
I then have a column of various numbers in column C C2 down to C6.
I want to sum up and display the numbers horizontally that matches up with the name.
In a cell D1 to display my answer I have this formula.
=SUMIFS(C2:C6,B2:B6,"Mary",B2:B6,"Jim")
Why does this not work? I would have thought I was saying addup the numbers in column c between C2 and C6 that only corresponds to the names Mary and Jim. However it doesnt work. Can someone tell me the correct method. I am new to SUMIF and SUMIFS. I could use SUMIF and it worked with one name but now I want to do 2 names.
thanks
Bookmarks