Who here is good at MS Excel?

[Amele]

Why did you make the and an or? That is most likely why its not working for the 2nd sample (80, 80, 80, 80, 80)

no. my statement doesn't work for the 2nd sample either (with and.) my statement was written to exclude this case:

{100, 90, 85, 85, 80} in the sense that it would only mark 80.

then you do a test in the 'keep' portion of the statement to identify if you have two things = 85 (which is complicated) and flag only one of them

in the case where *all* values are min, mine would would still fail (in this case, it wouldn't mark any of them)

[viperlasson]

Why did you make the and an or?

I had to make it an OR because with AND it always returned the FALSE value "keep".

edit: nevermind your AND statement works with my final list, don't know what was happening before

Ughh one more problem I need help with then I am DONE. Here is my finished Chapters sheet, the one that needed the keeps, no keeps,

http://img267.imageshack.us/img267/4230/sdfabk3.jpg

Now what I need to do is to make the assignments with the "don't keep" value get knocked out of the points possible field and your points field. Need to make them equal to zero perhaps? I don't know how I would do that, in the =SUM(B2:B17) I would have to add some function that would subtract the possible point values that correspond to the don't keep value. And same with the =SUM(C2:C17) subtracting the two lowest grades from the total sum which also correspond to the don't keep values. This really is a pain in the ass.

[souleman]

I already showed you how to do it for the "Your Score" field.

I don't feel like writing another Excel function, so I'll just tell you that for Ponits Possible, you need to use the SUMIF function.

[Amele]

SUMIF is one way; the other is SUM(IF(1),IF(2),etc)

SUMIF is better, but depending on the requirements of the assignment (whether it's about all 'if' statements, or only about IF statements) the latter may be what your professor is looking for.

[viperlasson]

So wouldn't this work for Points Possible?

=SUMIF(C2:C17, ">(OR(SMALL(C2:C17, 1), SMALL(C2:C17, 2))", B2:B17)

its checking the Your Score range, seeing if it is greater than the lowest value OR 2nd lowest value, if it is greater: add the value in the B column

It is always returning 0.

I promise this is the last question >_>;;

[Amele]

first, OR() returns boolean values (true, false) so it doesn't work the way you're trying to make it work.
second, there's a help file; you should read about functions you're trying to use (especially stuff like 'or')
third, I'd be sumif'ing based on whether or not exact(x,keep) since you already did the work on what to keep or toss.

if you're confusing yourself with sumif; just do SUM(IF(keepA1, A1, 0), IF(keepA2,A2,0) etc. it'll be alot longer but it's a 'simpler' function set, so you're less likely to confuse yourself. (it's basically the rolled out version of SUMIF)

[viperlasson]

That would make it so much easier wouldn't it? I am not thinking straight, this is due in ~25mins via email.

=SUMIF(D2:D17, "=yes", B2:B17) works

I had to change the keeps and not keeps to yes's an no's as required by the assignment. Thanks very much for the quick reply and always accurate information :D
Finally I am finished, time to go back to sleep.