Conditional formula or not?

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.
 
B

BoniM

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
Help with Iif on Report 4
Conditional Formatting 2
How many males and how many females 4
precede or follow formula with text 2
How do I set up an IF formula with multiple qualifiers? 4
Summing rows based upon condition 2

Top