COUNTIF

[Nath]

Hi

I am trying to use the countif function, i dont think that
it will be the correct one, but here is an outline of what
i wish to achieve. I have a sheet as detailed below.

Name Crit1 Crit2 Crit3 Crit4 SumCrit
A 1 1 0 1 3
B 1 1 1 1 4
C 1 0 1 1 3

What i wish to do is to count all the instances of a name,
where the sum of the criteria (sumcrit) = 4

Is this possible.

TIA

Nath

 

[Frank Kabel]

Hi
does the following work for you:
=COUNTIF(F:F,4)

 

[JE McGimpsey]

One way (assuming SumCrit is in column F):

=COUNTIF(F:F,4)

 

[nath]

It would do, but it also needs to check that the 4 is
associated with their name, what i need is a combination of

countif(a:a,"name")
and
countif(f:f,4)

Any ideas?

TIA

Nath.

 

[JE McGimpsey]

one way:

=SUMPRODUCT(--(A1:A100="name"),--(F1:F100=4))


See

http://www.mcgimpsey.com/excel/doubleneg.html

for an explanation of --.