Summing Using Text Characters as Criteria

In this article, you will learn how to sum the value by using text characters as criteria in Microsoft Excel.

SUMIF function is used to add the numbers in a range on the basis of specific criteria.

image 1

 

Let’s take an example to understand how we can sum the text character as criteria.

We have data in range A1:B11. Column A contains the list of Sales persons, and Column B contains sales amount. We want to return the total value for agent only.

image 2

 

Follow below given steps:-

  • Select the cell C2.
  • Write the formula =SUMIF(A:A,"Agent",B:B)
  • Press Enter on your keyboard.
  • The function will return the total value to Agent.

image 3

 

Let’s take another example

We have data in range A1:B11. Column A contains the list of Sales persons and Column B contains sales amount.

image 4

 

In the above-shown example, we want to return the total amount for all agents, in cell C2.

 

Follow below given steps and formula:-

  • Select the cell C2.
  • Write the formula =SUMIF(A:A,"Agent*",B:B)
  • Press enter on your keyboard.
  • The function will return the total value to Agents.

image 5

 

Conclusion:- If you want to retrieve the total value for particular criteria, we can use SUMIF function in above-mentioned ways.

image 48

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 

Users are saying about us...

  1. I found this tip to be just what I needed when trying to pick out cells that contained dates and then summing the associated values. My problem was that I wanted only the various dates and not the cells that contained other text. I found that by using "*/*" the =SUMIF would extract only the cells containing the dates. Absolutely perfect and I am so grateful!!! Shirlene

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube