Pivot Table exclude negative values from sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel 2007:
I am using a pivot table to sum staff by department. Some departments have
positions shown as a negative (indicates they belong to a different
department/budget). When I include the FTE column in my pivot table to
summarize staffing by department, it adds the negatives making the total
incorrect.
How can I get the table to sum only if values are greater than zero?
 
You could add an extra field into your source data flagging negative values.
Assuming your FTE's are in colmun B you could use a formula like =B2>0 to
return simple true false flags...
 
Perfect. Thank you for the idea. That worked.

Jim Thomlinson said:
You could add an extra field into your source data flagging negative values.
Assuming your FTE's are in colmun B you could use a formula like =B2>0 to
return simple true false flags...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top