Excel 2007 : Attendance formula

I am brand new to the forum, although I do not consider myself a "newbie" to Excel.

I am having a very hard time with the following:
This is a sheet to track attendance
Column A = codes
Column B = names
Column C-BN = Dates of the year

I need to find out how many people attended that have a specific code listed in column A

So, if John Doe has a specific code that I am looking for and he is markes as Yes in column H for attending, as well as Jane Doe and so one, I need to find the running total.

I would suggest you upload a sample workbook with some typical data.

Regards

Still a bit confused. Can you give a specific example? What cell do you want the sum in? What result? Why? Pseudo formula, maybe? Where do you want the "running total"?

Incidentally,

=COUNTIF(H2:H79,"yes")/(COUNTA(H2:H79)+COUNTBLANK(H2:H79))

could be replaced by:

=COUNTIF(H2:H79,"yes")/ROWS(H2:H79)


Regards

I would like to have excel return the count of people that have the code of YSA to cell H84, but only if they attended.
Column H says that if they attended once for the whole month, they are counted as attended. I will need the formula to use column H as the reference on if they attended or not.
So, I need the total count of people who attended from column H but only if the person has a code of YSA from column A.

I hope I am wording this right.

I have also attached a new file for you to look at. The old one did not have all of the rows.

H84 formula: =COUNTIFS(A2:A79,"YSA",H2:H79,"Yes")


PS: Please update your profile. It says 2003 but you've uploaded a 2007/2010 type file.

Regards

You're welcome.

If this has answered your problem, please mark your thread as solved. See my signature for details or the FAQ.

Regards