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?
|