Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've started using Excel's PivotChart to analyze data about customer requests. All my customer requests is stored in a sheet, with columns like "City", "Inspectiondate" and "Quotedate". If there was no quote created for that particular request, "Quotedate" will simply be blank. Now i'd like to present how many of the requests that got quotes for each city. Now my problem is that i can add the "Quotedate"-field to my PivotChart, but it counts the blank rows as well. How can i make the PivotChart not count the blank rows?

share|improve this question
You could either filter-out the blank entries of the source data or add a filter to the pivot configuration. – Axel Kemper Apr 1 '13 at 12:55

If i understand your problem correct you want to know how many quote you have per city. You can add another column next to "Quotedate" that will have this formula =IF(AF91="";0;1) change AF91 to your need and simply just add that column to your pivot table as sum

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.