how do i detect like text and add corresponding values?

L

Lucy

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?
 
F

Frank Kabel

Hi
you may have a look at SUMIF for this. Additionally: provide some example
data of what you're exactly trying to do
 
D

Dave O

Hi, Lucy-
Checkout the SUMIF() function to see if it will work with your data.

Dave O
 
Top