The sheets are named Bob, Joe Bill etc. And yes, I do add and move sheets
frequently. All the sheets are copied and so they are the same structure. I
am looking for the same cell on each sheet. What I am trying to do is if a
person started on a particular date which is in cell A1 than add their
tuition which is in C1. I have done some reading on the THREED formula, but
when I use that I get a #REF! error. I really appreciate your help with
this. Thank you so much.

"Bill Pfister" wrote:

Are your worksheets dynamic name and quantity (i.e. are the sheet names Bob,
Joe, Bill, etc. or sheet1, sheet2, sheet3 and do you frequently add and
remove sheets)? Is each individual's sheet similary structured (are you
looking at the same cell or range of cells on each sheet)?

Regards,
Bill


"Tracy" wrote:

I have created a worksheet for each individual person. I am trying to create
a formula that will filter though the different worksheets and sum the
people who have started on a specific date. Can somebody please tell me how
to do this or if it can even be done.

Thank you,

Tracy