Hopefully, you noticed my typo.
The formula was right, but it goes in C2, not C1.

This...
C1: =HLOOKUP(B2,$A$20:$I$21,2,1)

Should have been...
C2: =HLOOKUP(B2,$A$20:$I$21,2,1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

It is kinda confusing to me<<

That's only because I was WAAAYYYY off the mark in tying to decipher what
you wanted.

------------------------
Let's see if I can redeem myself with your second question.....

with
your data list in cells A1:C11
(Names in Col_A, Avg in Col_B, Grade in Col_C)
and
your grade table in cells A20:I21

Bragg's grade in C2 would be
C1: =HLOOKUP(B2,$A$20:$I$21,2,1)
Copy that cell down through C11

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Mandy" wrote:

It is kinda confusing to me

"Ron Coderre" wrote:

Let's see if I understand you correctly.....

With
A1: 5
B1: 10
C1: 13
D1: 15

The sum is 43,
but
Number 15 is greater than 13...so add 1
Number 5 and 10 are less than 13....so subtract 2*2 (4)
Final total = 43+1-4=40

If that's correct, than
E1: =SUM(A1:D1)+COUNTIF(A1:D1,"13")-COUNTIF(A1:D1,"<13")*2

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Mandy" wrote:

I have a question, I am trying to work on a grade book spread sheet and I am
having no luck.

If a number is more than 13 in a box then it should ad 1 to each number over.
If a nubme is less than 13 then there is a 2 point deduction for each number.

I think I need to use a if then statement right?