Total of cells

[Guest]

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

 

[Guest]

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

 

[PCLIVE]

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