• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

Excel formula question

is it possible to make a formula that checks a range A1:A100 for certain words.. and if that word is in a field.. itll add up the sum of all the B fields that have the word in field A?

for example if it looked like this.. it would return 6

Test          3
Test          2
kajdfa       9
adfjkadf    9
ajdfjda      8
Test          1

  • 2
2 Solutions
Ardhendu SarangiSr. Project ManagerCommented:
you can use SUMIF function for this.
barry houdiniCommented:
You can use SUMIF, i.e.


regards, barry
bail3yzAuthor Commented:
Thanks!.. perfect
Ardhendu SarangiSr. Project ManagerCommented:

Like this - =SUMIF(E2:F7,"Test",F2:F7)

Assuming your data is in columns E and F, where E contains the words and F contains the values.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now