| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using 'The count of' column in a pivot table formula | Excel Discussion (Misc queries) | |||
| Unique records in pivot table - formula? | Excel Discussion (Misc queries) | |||
| pivot count unique records only | Excel Discussion (Misc queries) | |||
| unique records in Pivot Table | Excel Discussion (Misc queries) | |||
| "How do I get rid of old records in an Pivot Table? | Excel Discussion (Misc queries) | |||
Linear Mode
