Total of cells
 

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

Total of cells
 

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

Total of cells
 

I'm assuming you're trying to match two criteria. For this you'll need to
use SUMPRODUCT. Your column ranges can't be refereced as "A:A". You must
specify a row range. (ex. - A1:A10.)

=SUMPRODUCT(--(A1:A10="T1"),--(B1:B10="MON"))

HTH,
Paul



"Neil" wrote in message
...
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