Repeat formula and sum it

[FRANCY]

Hi Everybody,

I have an infinite number of rows. Every row has 3 cells. A cell can contain YES or NO.
     A     B       C     D
 1 yes    yes   yes
 2 no     yes   no
 3 yes     yes  yes
4
......
If the row contains 3 YES than 1 has to appear, otherwise 0. I used this formula:

=IF(AND(A1="yes";B1="yes";C1="yes");1;0).

 I want to make appear in D4 the sum of the results of the formulas of the different rows: In this case 2 (1+0+1).
 My problem is that I want to comprime all the calculations in cell D4. That means that i do not want to repeat the formula =IF(AND(A1="yes";B1="yes";C1="yes");1;0) for every row and than sum the results together. Instead I want a unique formula in an unique cell (in my case D4)which makes repaet my IF formula for my infinite rows and than sum the results together.

Sorry for the complicated explanation... I do not know how to explain it better.

Thanks in Advance

[Jonas0806]

Hi,

=countif(A1:C1,"yes") for each row, =countif(A1:C100,"yes") for total sum.

By the way, this is a German-speaking forum ;)

[WillWissen]

Hallo,

meinst du so?

Tabelle7

	A	B	C	D
1	Ja	Ja	Ja	1
2	Nein	Ja	Nein	0
3	Ja	Ja	Ja	1

Formeln der Tabelle

Zelle Formel D1 =WENN(ZÄHLENWENN(A1:C1;"ja")=3;1;0)

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4.8

Btw, in diesem Forum ist die "Amtssprache" deutsch. Ich bitte dich deshalb deine Fragen zukünftig auf deutsch zu schreiben oder übersetzen zu lassen.

[FRANCY]

Vielen Dank für eure Hilfe.

Nächstes Mal schreibe ich auf deutsch:)