Conditional formula or not?

  • Thread starter Thread starter shamor
  • Start date Start date
S

shamor

I have a column that has X if attended class then I need a sum of the number
of students that attended on that column. What is the easiest way to do this
without having to use the number 1 for attendance? so, issue is sum any X in
a column and total at the bottom.

Thank you.
 
If x's are the only data in the column... you don't put anything if they did
not attend... then you can just count the cells that contain data:
=COUNTA(E2:E21)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum if 4
Using Excel as a markbook for attendance and assessment 1
Conditional Formatting 2
ATTENDANCE SPREADSHEET 5
Excel Formulas 6
sumproduct with 4 conditions 1
Query for specific characters in a spreadsheet 1
Changing cell color with a formula? 3

Back
Top