Hi Daddy and thanx for your answer.
What I'm trying to do is to sum some cells if they contain a name.
=IF(K7=0;250+J7;250-K7)
I used this funktion, but the prolem is that it sums the other cells that I
don't want to sum.
I work in a school and I'm trying to make this cheet cause I give the
students some points every week. This week I have maybe two students but the
other week I may have three or five. So what I'm trying to do is to keep the
cheet as it is and find a funktion that helps me that if I typed a name in
the first cell then it sums the other point cells.
--
Moualla


"daddylonglegs" skrev:


Can you explain a bit more and use an example?

You can count cells based on content using COUNTIF or sum cells based
on their content or content of other cells using SUMIF - will that
help?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=504456