Hi Neil,

If you are trying to count how many times Monday appears in a list for
example, use 'countif'. If you follow the formula bar or

=countif(A1:A45,b1)

A1 : A45 are the rows you are counting if Monday appears
B1 has 'Monday' in it

Hope this helps

Amanda



"Neil" wrote:

How can i count the total of cells if they match a certain criteria?

Eg

A B
1 T1 MON

So i can total all the number of times this occurs in the rows?

Many Thanks