Solved Summarizing Checklists in Excel or Word

July 23, 2012 at 12:44:02
Specs: Windows XP
Hey guys,

I have written up a checklist in Word.
It's designed to track 50 different training modules that are required to be taken by employees.
There is a box to check by any training modules that have been taken, otherwise it is left blank.

Now, I have over 40 employees that need to be doing these training modules, and I don't want to double my efforts by asking repeat questions, etc.

I want to have a way to summarize how many employees have finished a certain training module, like "35/41 finished this training module"
I also want to keep track of who has taken which training modules.

Is there a way that I can have these functions written up in something like Excel or Word?
If not, could someone point me in the right direction so that I could have those kind of functions?

See More: Summarizing Checklists in Excel or Word

July 23, 2012 at 19:39:25
If your data was in Excel, there are a few members that could probably help you out.

If it's in Word, you may have to go elsewhere.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

July 24, 2012 at 05:23:18
I could put the data into Excel, no problem.
I am just unsure as to whether or not Excel can handle this type of function.

Any ideas?

Report •

July 24, 2012 at 11:57:05
✔ Best Answer
You could do something like:

        A            B       C       D       E       F         G
1) Name / Module   Mod 1   Mod 2   Mod 3   Mod 4   Mod 5   
2) John Smith      x       x                               2 of 5 Modules
3) Harry Green                                             
4) Susan White                                             
6)              1 of 3 Emp.                                     

In cell G2 enter the formula:

=COUNTA(B2:F2)&" of "&COUNTA(B$1:F$1)&" Modules"

In cell B6 enter the formula:

=COUNTA(B2:B4)&" of "&COUNTA($A2:$A4)&" Emp."

Drag the formula down & across.

Gives you something to start with.


Report •
Related Solutions

Ask Question