Using COUNTA horizontally

[Dsheaff]

I need a formula that will count the number of times the value "N" appears in cell B10 and E10....if "N" does not appear in either cell, the recipient cell (cell G10) is to remain blank

Tree Trimming Requirement Met

Mowing Requirement Met

A

B

C

D

E

F

G

Yes

No

CEAP *

Yes

No

CEAP *

Number of Times Requirement Not Met

(Y)

(N)

(X)

(Y)

(N)

(X)

N

N

<colgroup><col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col width="64" style="width: 48pt;"> <col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col width="64" style="width: 48pt;"> <col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col width="64" style="width: 48pt;"> <col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col width="10" style="width: 8pt; mso-width-source: userset; mso-width-alt: 365;"> <col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col width="64" style="width: 48pt;"> <col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col width="64" style="width: 48pt;"> <col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col width="64" style="width: 48pt;"> <col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col width="10" style="width: 8pt; mso-width-source: userset; mso-width-alt: 365;"> <col width="52" style="width: 39pt; mso-width-source: userset; mso-width-alt: 1901;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>

 

[Joe4]

Welcome to the Board!

One way:

=IF((E10="N")+(G10="N")>0,(E10="N")+(G10="N"),"")

 

[jtakw]

Hi,

Joe4 had a typo in his formula (fixed in G10), and I included another way to write it (H10), just in case you meant to count the range B10:E10, use I10

Book1
	B	C	D	E	F	G	H	I
10	N	X	Y	N		2	2	2
Sheet180

Cell Formulas
Range	Formula
G10	=IF((B10="N")+(E10="N"),(B10="N")+(E10="N"),"")
H10	=IF(OR(B10="N",E10="N"),(B10="N")+(E10="N"),"")
I10	=IF(COUNTIF(B10:E10,"N"),COUNTIF(B10:E10,"N"),"")

 

[Joe4]

Joe4 had a typo in his formula (fixed in G10), and I included another way to write it (H10), just in case you meant to count the range B10:E10, use I10

Good catch.
Thank you.