Are you looking for an editor that will let you make that last-moment edit and Finish Sum Text For Free? Then you're in the right place! With DocHub, you can quickly make any required changes to your document, no matter its file format. Your output documents will look more professional and compelling-no need to download any software taking up a lot of space. You can use our editor at the convenience of your browser.
When utilizing our editor, stay reassured that your data is encrypted and shielded from prying eyes. We adhere to major data protection and eCommerce standards to ensure your experience is safe and enjoyable at every point of interaction with our editor! If you need assistance with optimizing your document, our professional support team is always ready to answer all your questions. You can also benefit from our comprehensive knowledge hub for self-assistance.
Try our editor now and Finish Sum Text For Free with ease!
hi guys welcome back to my channel a my tutorial so lets say you have data which looks something like this where you have brand and city in one column and the quantity against this against it and youre trying to sum the values against only the brand but not the city so we can achieve this by using this simple sum a formula with a little tweak to it so lets get started Im going to teach you how to do that so Im going to start with typing is equals to and sum F open bracket Im going to select the range which is the brand and City column here my criteria is going to be the brand column your comma and my son range is obviously going to be my quantity Im going to close the bracket and press Enter so as you can see weve got the value is zero because obviously Excel is looking for this exact word in this particular range now what we need to tell Excel to do is we need to tell Excel to look for this particular word in this range but not the exact but use the wildcard know how we can d