• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • 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

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

=SUMIF(A1:A100,"Test",B1:B100)

regards, barry
0
 
bail3yzAuthor Commented:
Thanks!.. perfect
0
 
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.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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