I am doing a count on a field and it is counting all the rows in the
column - even though most of them are blank.

This could be because of the formula I have in all the cells.

I basically have a formula (in Y2) that says
=if((k2)="Completed",K2,"")

So if K2 has a value it populates Y2 with that value otherwise it puts
nothing ("").

Any ideas how to keep it from counting every row.

Thanks
Jim