Excel 2000 - Advanced IF AND ELSE COUNTIF??

[halo14]

hey there..

I have a large spreadsheet for rental properties. and I want a total a
the bottom of how many are ready to move in, according to # o
bedrooms.

I have a total at the bottom that totals the number of each
1,2,3,4,5,6 bedrooms.That's just a simple COUTIF statment.

Here's the set-up:

Column C is filled with the # of bedrooms, varying from 1-6. Column
contains a date ready, if it's ready. If the unit is not ready there i
no date.. so basically if there is anything in that field it counts it


Now I need 6 totalling fields: because I want to know the number of
bedrooms available, 2 bedrooms available, etc... I can't figure ou
how to write that statment.. It needs to equal the followin
criteria:

Scan column C for values of "1" and then scan Column N for values o

"" and then count all of those rows which are true to that criteria.

Is this even possible?

Thanks for your help

 

[Aladin Akyurek]

=SUMPRODUCT(--($C$2:$C$100=1),--(ISNUMBER($N$2:$N$100))