The SUMIF function can also be used to apply the criteria to one range and sum the corresponding values in a different range.
So if you have a list of Sales Reps in one list and their Sales in another list and want to Sum the sales of only one of the Sales Reps, then the SUMIF function is the one for you.
You make excel very easy to understand. I remain one of your students. Thanks
Hi Uche,
Thank you for your feedback, and we plan to help you Excel in Excel even more!
Kind Regards,
Bryan
Perfect training which is understandable by the beginner
Hello Malcoom,
It makes my day when I hear that my blog is easy to understand and helps people like yourself.
Keep up the good work 🙂
Cheers,
John
