PDA

View Full Version : Pivot Table Count ?



Dabo
06-28-2009, 03:43 AM
Hi there,

I have a very easy problem I guess, but I cannot figure out how to solve it:

On the attached file, I have 3 columns A B C, the data in the columns is either Yes or No and I just want a pivot table with :
A B C
Yes 3 3 5
No 2 1 0

What is the layout to use ?

I joined an attached file to show you better.

Thanks !

Bob Phillips
06-28-2009, 10:56 PM
Just use simple formulae

=COUNTIF(D$10:D$15,$I9)

and copy across and down

Dabo
06-29-2009, 01:03 AM
Thanks !
No way to get the same result with a pivot table ?
I would swear it is possible