Maybe you could use an =countif() statement:

=countif(b2:g2,""&0)



Bec G (Oz) wrote:

I have a pivot table where the columns are months and the rows are vacant
staff positions. If the position needs a person in it that month it will have
a one in it, if it does not need to have a person in it the value will be
zero.

What I need is a formula which will allow me to identify the number of new
positions each month. The Sum doesn't work as it only returns the total
number of new positions needing to be filled and one position may be filled
one month but not the next.

Any help is greatly appreciated

Bec G

--

Dave Peterson