Countif Formula
Couldn't get that to work...
Eduardo wrote:
Hi,
=if(or(H1:H1000="HOUSES",H1:H1000="CONDOS"),count( I1:I1000,"Alabama","")
if neither houses or condos are in column H the formula will display a blank
"Lime" wrote:
This has to be easy...
column "J" I need to count how many times "Alabama" shows in column "I" only
if column "H" = either "HOUSES" or "CONDOS" or "Apartments"
ANy help would be appreacited.
|