Can I Use a Count Function for Text?
thanks for your help!!
"T. Valko" wrote:
Maybe this:
=SUMPRODUCT(--(B1:B10="O"),--(C1:C10="house"))
Note that with SUMPRODUCT you *can't* use entire columns as range references
unless you're using Excel 2007
--
Biff
Microsoft Excel MVP
"kEV" wrote in message
...
Hi,
Can anyone please help, i'm trying to count the total number of
occupancies
"O" in column B are for "house" in column C - Dcounta and countif dont
seem
to be working - any suggestions
thanks
|