I wasn't really sure how to search this in the archives so I didn't
find much, but here goes:

I have created a workbook to track continuing education hours/credits
for different certifications. There are two variable components: There
are blanks on one sheet for up to eight different certifications, and
then four other workseets to track different kinds of CE seperately
(classroom, cbt, etc). The certifications are variable throughout the
entire workbook based on a cell reference on the certification sheet
(A1:A8) The values of these cells enter automatically on the
subsequent sheets with checkboxes below to indicate if the CE is
applicable to the corresponding certification above. The checkboxes
are linked to the cells immediately beneath them, so a running hour
total at the bottom for the individual certification is based on a
SUMIF (TRUE) formula.

I would like for the user to be able to generate a summary of all the
individual training items that are applicable to the individual
certifications in sheet1(A1:A8).

On the sheet with the individual training items, they are laid out like
this:
Date Class Hours =Sheet1(A1) =Sheet1(A2) etc...


The cell references are easy, the variable will always be a cell
reference(Sheet1-A1) and the criteria for inclusion will be a TRUE
value, but I've got no idea how to put that together.

I've likely not explained this very well, so anyone willing to help can
download the work in progress to see what I need he
http://upload2.net/page/download/GO4...Blank.xls.html

Thanks.