How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1832
Experience:  20 years experience providing remote computer support
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

I need help! Id like a formula that checks the field in column

This answer was rated:

I need help! I'd like a formula that checks the field in column A for all those instances that match, and then --for matching rows-- adds up the numerical string that appears in column E.

I haven't got much Excel experience.
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

try something like this

=SUMIF(A:A,"Value you want to match",E:E)

the value you want to match must be in quotes.

If you need any modifications to the formula please let me know.
Customer: replied 3 years ago.

Thanks! Quick question. This would mean I would have to do the formula for each value I want to match. Is that true?


Ideally, it would just find and combine all those rows that match. Is that too much to ask of Excel, or is it possible?



well you would have to do a formula for each value you wanted to match, and it would match all of those values, in the column.

for example if the column had 5 instances of the word "baseball" it would add all of those numbers. If you wanted to look for a different value say "basketball", it would add all of the instances of that one. You can also refer to another cell in the formula.

Here is an example sheet that shows it both ways.
The-PC-Guy and 2 other Microsoft Office Specialists are ready to help you