Formula to count new records in pivot table
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 |
Formula to count new records in pivot table
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 |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com