Countif And Function Help

[william.mcseveney]

Hi

I need a forumula that will count the number of cells in a column with
a particular code eg AM1, and then look across a couple of columns and
check if that column has eg a 1 in it, if the result is true I want
the actual count of the number of cells referring to the code AM1 that
also meet the 2nd criteria.

hope that makes sense.

Many thanks

Will

 

[T. Valko]

Try something like this:

=SUMPRODUCT(--(A1:A100="AM1"),--(C1:C100=1))