how do i detect like text and add corresponding values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of recurring names. Each name has several corresponding values.
I want to add teh values that correspond to the recurring names. I have so
far used 8 nested if caluses but now I have exhausted the number of formulas
you are allowed in a cell. any ideas?
 
Hi
you may have a look at SUMIF for this. Additionally: provide some example
data of what you're exactly trying to do
 
Hi, Lucy-
Checkout the SUMIF() function to see if it will work with your data.

Dave O
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Corresponding Cell Value 2
retrieving values from a certain column 2
organizing rows and columns by text 1
Nesting a sumproduct formula within a sumif formula. 2
search from range in column 1 and print from corresponding values 1
EMBED VLOOKUP AND SIMPLE IF FORMULA IN A WORKBOOK 13
Looking up a value in column to return corresponding text on value 1
lookup H&V...or match...index??? 6

Back
Top