Count the numbers of 1 column where an other column meets a creteria?

  • Thread starter Thread starter Michel
  • Start date Start date
M

Michel

I like to count all the numbers from 1 column where the text in an
other column starts with a specific letter like:

Matrix | 20
Bad Man | 9
Mad Max | 12
Inferno | 2

count "M*" would give 32

I like to have it in a cell function not with VBA programming

Can this be done, maybe within a few cells?
 
Thanks!

Now I need to find out how I can count the numbers of 1 column if 2
columns meet each a different creteria?
 
Hi
maybe something like
=SUMPRODUCT(--(A1:A100<>""),--(B1:B100="crit_1"),--(C1:C100="crit_2"))
this will count the number of occurences. If you want to sum the
contents of column A try
=SUMPRODUCT(--(B1:B100="crit_1"),--(C1:C100="crit_2"),A1:A100)
 
Back
Top