Skip to content

EXCEL – countifs – counting multiple criteria

January 8, 2018

In this example, a gradebook is counting up two different criteria – both absence (abs) and tardiness (late) as marked in book.  Rather than manually counting these entries, this formula makes automates the process.  In addition, either a reward for good attendance can be added to the final grade or a penalty can be deducted for those with poor attendance.   I’ve also included the file if you wish to follow along.

excel file

 

Advertisements

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: