Need help with an Excel function?

Question

I am creating a spreadsheet on Excel in order to track attendance at my organization's meetings. The names of the members are along the left side, and each successive column represents each meeting. In these columns, I put in an "E" denoting an excused absence and a "U" for an unexcused absence whenever a member is not at a meeting.

My question is how to make two functions at the bottom of each column. One function will add the number of E's in that column, and the other will add the number of U's. This should show how many absentees were excused and how many were unexcused.

For example, in C5 through C22, there is one E and two U's. I want to put a function in C23 that adds the E's in the C column, and another in C24 that adds the U's.

Thanks.

Answer 1

you would use the CountIF function in Excel

http://www.techonthenet.com/excel/formul...

for example you would put in C23... '=CountIF(C5:C22, "E")'

and in C24 ... '=CountIF(C5:C22, "U")'

Answer 2

OK here's how I'd do it:

If your data range is C5-C22 as depicted in your question, then in C23 I'd have something to tell me how many are E and in C24 I'd have how many are U.

Example

B23: TOTAL EXCUSED ABSENCES

C23: =COUNTIF(C5:C22,"E")

B24: TOTAL UNEXCUSED ABSENCES

C24: =COUNTIF(C5:C22,"U")