Need help with SUMIF task

Occasional Visitor

Hi,
Could someone help me sort out how to solve the task below? 

"Your name, as well as other names are listed in column A, all the way down to row 300. In column B there are different value (any value). How would you sum up the values where your name is listed?

 

I haven´t been working much with Excel, more than really basic knowledge, so I would really appreciate if someone could help me figure this one out.

 

Thanks!

1 Reply

@KarinHaninge 

=SUMIF($A$2:$A$300,"Your Name",$B$2:$B$300)
=SUMPRODUCT(($A$2:$A$300="Your Name")*$B$2:$B$300)

You can try the formulas above to sum all values with "Your Name" in range A2:A300.

=SUMIF($A$2:$A$300,C1,$B$2:$B$300)

With this formula you can dynamically enter any name from range A2:A300 in cell C1.

SUMIF.JPG