Countif to use for several columns at the same time ...

[camitava]

Hi,


I am using an excel file with the following format -
Chapter| Start Page|# Of Page|"Status (N/R/D)"
1 | 1 |6 |N
2 | 7 |20 |N
3 | 27 |20 |R
4 | 47 |16 |D

- I used the pipe sign (|) to separate the columns here.
Anyway, I want to use an excel function that will work on two columns - "# Of Page" and "Status (N/R/D)". The function is required to do the following -
1. Filter the "# of Page" column to select those chapters only with no of pages between 10 and 15.
2. Filter the "Status (N/R/D)" column to show only those rows with "N" as status.
3 & Overall. I need the count of those rows matching the condition 1 &2.

My question is - Is it possible to use any combination of excel function to do this operation. I do not want to use any excel macro but am trying to limit myself to an excel function.