If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|