Posted by: tonyteaching | February 15, 2009

Ms. Excel 2007: to Count IF

Often we want to summary the total number of particular value, for example: we want to summary how many students got HD, DN, or CR?

Simply just using formula COUNTIF

= COUNTIF (Range of the data, cell position of value as reference)

for example:

= COUNTIF ($A$2;$A$12, I13)

it is said “put value in this cell with the number of values in range $A$2;$A$12  which contains data same with I13”


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Categories

%d bloggers like this: