| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
COUNTIF with multiple criteria?
I have a table with a column that indicates if the record is for a "House" or
an "Apartment" and a second column that indicates if it is "Occupied" or "Vacant". How do I wite a formula to count all the houses that are vacant ? -- cyberindio |
|
#2
|
|||
|
|||
|
Hi!
Try this: =SUMPRODUCT(--(A1:A100="House"),--(B1:B100="Vacant")) Biff "cyberindio" wrote in message ... I have a table with a column that indicates if the record is for a "House" or an "Apartment" and a second column that indicates if it is "Occupied" or "Vacant". How do I wite a formula to count all the houses that are vacant ? -- cyberindio |
|
#3
|
|||
|
|||
|
Thanks Biff, but I can't seem to get it to work. I get a "0" answer when
there have to be at least 1500 records that fit the criteria. I used the exact syntax you gave me but it might be multiplying zeros. "Biff" wrote: Hi! Try this: =SUMPRODUCT(--(A1:A100="House"),--(B1:B100="Vacant")) Biff "cyberindio" wrote in message ... I have a table with a column that indicates if the record is for a "House" or an "Apartment" and a second column that indicates if it is "Occupied" or "Vacant". How do I wite a formula to count all the houses that are vacant ? -- cyberindio |
|
#4
|
|||
|
|||
|
Are you sure you adjusted the ranges correctly?
No leading or trailing spaces? In article , "cyberindio" wrote: Thanks Biff, but I can't seem to get it to work. I get a "0" answer when there have to be at least 1500 records that fit the criteria. I used the exact syntax you gave me but it might be multiplying zeros. |
|
#5
|
|||
|
|||
|
Try
=SUMPRODUCT(--(Trim(A1:A100)="House"),--(Trim(B1:B100)="Vacant")) -- HTH RP (remove nothere from the email address if mailing direct) "cyberindio" wrote in message ... Thanks Biff, but I can't seem to get it to work. I get a "0" answer when there have to be at least 1500 records that fit the criteria. I used the exact syntax you gave me but it might be multiplying zeros. "Biff" wrote: Hi! Try this: =SUMPRODUCT(--(A1:A100="House"),--(B1:B100="Vacant")) Biff "cyberindio" wrote in message ... I have a table with a column that indicates if the record is for a "House" or an "Apartment" and a second column that indicates if it is "Occupied" or "Vacant". How do I wite a formula to count all the houses that are vacant ? -- cyberindio |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| Countif formula with multiple criteria ie >30 and <60? | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Hybrid Mode
