Hi, I am trying to develop a formula to have attendance reports and averages.
I want to divide the groups into adults, youth and children. I have a column
identifying the group each person is in (A Y or C).

I have a worksheet for each program (wed, thurs, fri or sun) and i want to
tally the totals on another sheet and then make an overall statistics sheet.

I am using =SUMIF(Sunday!B:B,"A",Sunday!E:E) on the initial stats but it is
coming up as an error.

I am using =AVERAGE(IF('Initial Stats '!4:40, 'Initial Stats '!4:4,""))

I thought I had everything set fine and when I opened the program today to
start entering data there were errors everywhere.

Thanks, Mary