Pivot for Yes, No and Blank

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

I have a sheet that is tracking responses to a class and
I would like to summarize on a pivot.

The sheet has four columns;
A = Name
B = Invitation Sent
C = Invitation Returned
D = Attending

B, C and D will then have a value of Yes or No or will be
blank - How can I create a pivot that will show me how
many have been sent, how many have been returned, and how
many will be attending?

Thanks.
 
Hi
IMHO your current layout is not well suited for a pivot table report
(you already have a structure quite similar to the pivot table). You
can easily add two total columns below this table to sum the 'Yes' and
'No' responses. e.g.
=COUNTIF(B:B,"Yes")
to count all sent invitations
 
Hello Frank,

Thank you for your quick response.

I was looking for something a little easier to
read/present - Something that would give me the overall
picture.

I suppose I could put the total columns at the top of the
sheet so that they are more visible, but I would have
preferred the pivot format, if possible.

Thanks.
 
If you are a newby, I wouldn't bother with a Pivot table. Just use the 'COUNTA' and 'COUNTBLANK' functions

Hope this helps you.
 
BRR - Thanks for the response - I am a Newbie, that's why
I was looking for something easy.

If the only thing for me to do is use COUNTIF, COUNTA
and/or COUNTBLANK, then I guess that's what I'll have to
do.

Thanks.
-----Original Message-----
If you are a newby, I wouldn't bother with a Pivot
Click to expand...
table. Just use the 'COUNTA' and 'COUNTBLANK' functions.
 
Thanks to BRR and Frank for responding.

I've now had a flash of inspiration and created a new tab
that uses some calculations based on the results of some
COUNTIF's an I've now got pretty much what I was after :-)

Thanks.
 
Back
Top