View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mercedes mercedes is offline
external usenet poster
 
Posts: 12
Default counting blank cells in a pivot table

I created a pivot table to keep count of inquiries and orders received. I
also want to a count of how many inquiries are quoted a day. I also want a
count of how many are left unquoted. To do that it would have to count the
blank fields under the inq. quoted column. I can only get it to count the
cells that have data in them but not the blank cells....how do I do that?