Excel 2007 : Multiply COUNTIF-NESTING FORMULAS PROBLEM

[bobigoca]

I have an workbook with several colons:name,educaton,evaluation and workplace
The main colons are D2:D291 for degree of education with duplicates
K2:K291 for workplace also with duplicates
N2:N291 for evaluation

Type of evaluations: 4 (3.5-4), 3(2.5-3.5), 2(1.5-2.5), 1(>0-1.5)
------------------------------------------------------------------
Need to count this

How many ??? with evaluation and workplace have 4,3,2,1
Here is an example

[dip11]

Use COUNTIFS.
Example for D304:
=COUNTIFS(N:N,">"&3.5,D:D,"Sre*")

Apply as required

[bobigoca]

This partialy helped, what will be the right solution for E304, where evaluations are between 2.5 and 3.5
Thanks a lot again

[protonLeah]

Please have a look:

[dip11]

This partialy helped, what will be the right solution for E304, where evaluations are between 2.5 and 3.5
Thanks a lot again

=COUNTIFS(N:N,">"&2.5,N:N,"<="&3.5,D:D,"Sre*")

[bobigoca]

Your example is very good, of course it will be used.Thanks a lot man, because evaluation is been made every year.
Write now making some program in C++, but together with Excel.
Thanks a lot again.

[bobigoca]

Your formula was OK.Tried and work good.But stil cant find 19 people, I believe all formulas are ok.

[bobigoca]

Please look at this example. Still cant find 19 results.
Thanks again for all help you provide.
ExampleValu1