Average numbers from a lookup function

[Guest]

I need to find the average GPA's from the Lookup function where I type in the
letter grade and lookup changes it to the gpa number, but then I need to
find the average...how do I do that? Bob from nowhere, help me again.....
thanks

 

[Bob Phillips]

Could you not just get each individual GPA into separate cells, and then
just run the AVERAGE function against those results?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

I tried that and I just got 0 as the result.....=Average(A2:R2) and it came
back 0,
thanks

 

[Bob Phillips]

What's in A2:R2?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

OOPS, I figured it out, I was including a 0 in the average and that was the
problem.....