Solved

Excel formula question

Posted on 2011-03-15
4
206 Views
Last Modified: 2012-05-11
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
Comment
Question by:bail3yz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 20

Assisted Solution

by:Ardhendu Sarangi
Ardhendu Sarangi earned 250 total points
ID: 35142057
you can use SUMIF function for this.
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 250 total points
ID: 35142060
You can use SUMIF, i.e.

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

regards, barry
0
 

Author Comment

by:bail3yz
ID: 35142063
Thanks!.. perfect
0
 
LVL 20

Expert Comment

by:Ardhendu Sarangi
ID: 35142086

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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook Free & Paid Tools
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question