Pivot Table - Is counting all rows

  • Thread starter Thread starter jblair
  • Start date Start date
J

jblair

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
 
=if(k2="completed",1,0)
And use sum (not count)

or
=--(k2="completed")
k2="completed" will be true or false
--(true or false) will be 1 or 0.

Count works like =counta(). If there's anything in the cell (even a formula
that evaluates to ""), it gets counted. The cell has to be really empty (no
formula, no value) not to be counted.
 
Back
Top