Add up specific letters in different columns.

[Geek Girl 007]

I want the E3 to add up all the N's and F3 to add up all the P's
This is the formula I used, but it's not working
=SUMIF(G3:J3,"N")

TEST.xlsx
	A	B	C	D	E	F	G	H	I	J
1					Total		February
2	Numer	Surname	First name	Activity	NEG	POS	Date	N/P	Date	N/P
3					0	0		N		P
Sheet3

Cell Formulas
Range	Formula
E3	E3	=SUMIF(G3:J3,"N")
F3	F3	=SUMIF(G3:J3,"P")

Cells with Data Validation
Cell	Allow	Criteria
H3	List	=Text!$A$1:$A$2
J3	List	=Text!$A$1:$A$2

 

[Fluff]

You need to use Countif not sumif.

 

[Geek Girl 007]

You need to use Countif not sumif.

Thank you
I was soooooo close

 

[Fluff]

You're welcome & thanks for the feedback.