Countif multiple criteria problem using text and numbers

[jmendenhall1960]

OK what I have is a list of names in this format: Mendenhall, John LPN, in A2 thru A70. In cell B2:B70 I have numbers with and without a letter example: 6p, 6d, 12p, 12d, D, ML, AL etc and the word "noon". What I want to do is countif the last letter in the name column A2:A70 has an "N" and if the number (always first digit) in the B column is >1 and countif A2:A70 has an "N" and B2:B70 "noon".
It really seems straight forward to me but for the life of me I can't figure out how to get excel to look at last and first digit in cell using the countif for two criteria.
Of course thank you for looking and any help.

 

[Peter_SSs]

OK, now I think I understand. Try these formulas, copied across. The colours were just for my benefit while testing but I've left them there as they do show what is counted by the formulas.

Excel Workbook
	A	B	C	D
1		18/05/2014	19/05/2014	20/05/2014
2	S	M	T
3	Raiy, Cheryl LPN	6P	12P	12P
4	Rach, Sandy LPN	D	D	12D
5	Brer, Denise DA	12P	12P	12P
6	Johnn, Darrell DA	7D	7D	7D
7	Seam, Doug DA	12D	D	D
8	Hais, Ed RN	7D	4P	D
9	Bnch, Connie LPN	D	6D	7D
10	Carell, Boyd LPN	ML	7P	7D
11	Fuish, Ray LPN	D	4D	4D
12	Bets, Ron DA	D	7D	7D
13
14	Bns, Joshua RN	4D	4D	4P
15	Paott, Felicia RN	D	7D	7P
16	Menhall, John LPN	4D	D	4D
17	Loerback, Rob DA	4P	D	D
18	Sthens, Willa DA	D	4P	4P
19	End
20	Days	2	3	3
21	2nd shift	2	3	3
22	Nights	0	1	2
Count Shifts

 

[jmendenhall1960]

Outstanding and thank you very much. Works like a charm Not sure how to show completed. I don't think I have closed any of my threads out correctly.

 

[Peter_SSs]

Outstanding and thank you very much. Works like a charm Not sure how to show completed. I don't think I have closed any of my threads out correctly.

Glad that worked for you.

We don't "close" threads in this forum. Somebody may come along later with an even better solution.

By coming back and saying that you are satisfied with a suggestion is all we would ask.