Countif worksheet function frustrations
Is there any reason why the first countif works but not the second?
{=COUNT(IF((bay.cost.1=B97)*(dept.1="DOTAG"),bay. cost.1))}
and it works, B97 is a currency value.
It works because bay.cost.1 are numeric values and that's what COUNT does.
It counts numbers.
{=COUNT(IF((mhc.lease.no=F17)*(mhc.dept="DOTAG"), mhc.lease.no))}
Your other formula would like this:
{=COUNT(IF((mhc.lease.no=F17)*(mhc.dept="DOTAG"),1 ))}
However, there's a better way to do this using non-array formulas:
=SUMPRODUCT(--(bay.cost.1=B97),--(dept.1="DOTAG"))
=SUMPRODUCT(--(mhc.lease.no=F17),--(mhc.dept="DOTAG"))
Biff
"Santa-D" wrote in message
ups.com...
I've got a worksheet that uses the following countif function:
{=COUNT(IF((bay.cost.1=B97)*(dept.1="DOTAG"),bay.c ost.1))}
and it works, B97 is a currency value.
In another worksheet I have
{=COUNT(IF((mhc.lease.no=F17)*(mhc.dept="DOTAG"),m hc.lease.no))}
Where F17 is a text field, but the second one doesn't work.
However, this works instead
{=SUM(IF((mhc.lease.no=F17)*(mhc.dept="DCS"),1,0)) }
Is there any reason why the first countif works but not the second?
|