Need help from the real world experts in Excel

[Atheria]

Hi all,

I am not an Excel person, I am a computer technician, but I have a
challenge - I have to come up with a spreadsheet that I can
then convert into a simple database - sound easy? Sound hard? Ok, let me
tell you what's so different about this particular problem...

This spreadsheet has to have the totals for people who have or have
not finished a SET of criteria/tasks.

Let me write it out and show you what I mean:

Name(field) Task Set(field) Accomplished as of now (field)
___________________________________________

Jan Set 1 3/5

Bob Set 1 4/5

Ron Set 1 5/5

Cam Set 1 0/5
_____
Total - xxxx (?)

Now, you can say - hey, just average them... but I need a total at
the end that shows an average of the above without making the
"5/5" into "1"(using a fraction field was how someone suggested it be done,
didn't work...)

So how in the world does one get an average of those numbers out
of a "set" of criteria that people have to do - say papers that they
need to fill out before the end of the month?

[Bryan Hessey]

Hi all,

I am not an Excel person, I am a computer technician, but I have a
challenge - I have to come up with a spreadsheet that I can
then convert into a simple database - sound easy? Sound hard? Ok, let me
tell you what's so different about this particular problem...

This spreadsheet has to have the totals for people who have or have
not finished a SET of criteria/tasks.

Let me write it out and show you what I mean:

Name(field) Task Set(field) Accomplished as of now (field)
___________________________________________

Jan Set 1 3/5

Bob Set 1 4/5

Ron Set 1 5/5

Cam Set 1 0/5
_____
Total - xxxx (?)

Now, you can say - hey, just average them... but I need a total at
the end that shows an average of the above without making the
"5/5" into "1"(using a fraction field was how someone suggested it be done,
didn't work...)

So how in the world does one get an average of those numbers out
of a "set" of criteria that people have to do - say papers that they
need to fill out before the end of the month?

Perhaps it's easier with helper columns

---