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.

Friends! I found the solution by using countifs() function. I used the formula as - =COUNTIFS($D$2:$D$55,"N",$C$2:$C$55,">10",$C$2:$C$ 55,"<16")

It worked and it gave me a good relief. Thanks anyway friends...

See you soon in this forum again probably with a new challenge :-P