Pivot for Yes, No and Blank

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.
 
F

Frank Kabel

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
 
N

Newbie

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.
 
B

BRR

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

Hope this helps you.
 
N

Newbie

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.
 
N

Newbie

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.
 
Top