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

"Lucy" wrote:

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, Lucy-
Checkout the SUMIF() function to see if it will work with your data.

Dave O


Lucy wrote:
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?