0

In an excel pivot table, I am looking to count all items created after the exit date for projects. None of the formulas have worked in the calculated field section.Several attempts listed below.

Projects is the Row Label. The calculated fields below were attempts to count the items created after exit per project.

  • ='Created On'>'Exit Date'
  • ='Created On'>'Exit Date'
  • =COUNT('Created On' >'Exit Date' )
  • = IF('Created On' >'Exit Date', 1, 0)

Here is a sample of the data:

Item Type     Created On        Project     Exit Date
Issue          12/12/17           ABC       10/6/2017
Risk           11/01/17           ABC       10/6/2017
Issue          12/14/17           ABC       10/6/2017
Risk           10/12/17           ABC       10/6/2017
Risk           10/30/17           ABC       10/6/2017
Issue          11/14/17           ABC       10/6/2017
Risk           10/13/17           ABC       10/6/2017
Risk           12/01/17           ABC       10/6/2017
Bug            10/11/17           ABC       10/6/2017
Risk           10/10/17           ABC       10/6/2017
Risk           11/06/17           ABC       10/6/2017
6
  • Needs sample data and expected results. Commented Jan 24, 2018 at 20:52
  • Added information above. Thank you Commented Jan 24, 2018 at 21:00
  • The expected results from the calculated field is the item count if the created on date is after the exit date. Thank you in advance. Commented Jan 24, 2018 at 21:34
  • =countif(b:b,">"&d:d) Commented Jan 25, 2018 at 1:44
  • =countif( 'Created On' ,">"& 'Exit Date') this formula displays an error in the calculated field section. Commented Jan 25, 2018 at 15:17

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.