Forum Discussion
Need help with SUMIF task
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 v...
=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.