Excel formula help Please

[pwevers]

I am trying to create a checklist. As an example, A2:A21 will be marked
with "N" if conditions are met. B2:B21 will also be marked this way.
I want to count the number of times that both A1 and B1(and so on) are
marked with "N".

Can anyone help me please??

 

[Frank Kabel]

I am trying to create a checklist. As an example, A2:A21 will be

marked with "N" if conditions are met. B2:B21 will also be marked
this way.
I want to count the number of times that both A1 and B1(and so on) are
marked with "N".

Can anyone help me please??

Hi you can use the following formula:
=SUMPRODUCT((A2:A21="N")*(B2:B21="N"))

you have to enter this formula as array formula (CTRL+SHIFT+ENTER)

HTH
Frank

 

[Peo Sjoblom]

Hi you can use the following formula:
=SUMPRODUCT((A2:A21="N")*(B2:B21="N"))

you have to enter this formula as array formula (CTRL+SHIFT+ENTER)

HTH
Frank

You don't have to array enter that formula

 

[pwevers]

Thank you so much for your help. I just stumbled across this foru
today. This is awesome!

 

[pwevers]

O.K. here goes another one. On another checklist I have 3 possible
errors to note in one cell designated with a "C", "U", or "P". How can
I get a tally for 2 if both "C" and "U" are entered in the same cell?

 

[pwevers]

Here is an example of what I am trying to do

Attachment filename: example1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=402737

 

[shades]

In cell B2, put this formula:

COUNTIF($A$1:$A$21,"*C*")+COUNTIF($A$1:$A$21,"*U*")