Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to ad onto an IF formula and I need help. I am using this formula
to count the number of apartments that are vacant. Some apartments have illegal tenants (squatters). The formula below counts how many are "vacant" or have "squatters", where squatters replaces vacant. The formula is: =COUNTIF(C2:C56,"Vacant") Now I need to count how many 1, 2, and 3 bedroom apartments are either vacant or have squatters. The D column shows either a 1 for 1 bedroom apartment, 2 for a 2 bedroom apartment, or 3 for a 3 bedroom apartment. I tried =COUNTIF(C2:C56,"Vacant",D2:D56) but it did not. What am I doing wrong. Thanks for any help out there |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Volatile not working as expected | Excel Discussion (Misc queries) | |||
# of Functions per cell | Excel Worksheet Functions | |||
# of Functions per cell >> More | Excel Worksheet Functions | |||
PivotTable canned functions | Excel Discussion (Misc queries) | |||
< and > functions aren"t working for me | Excel Worksheet Functions |