How to calculate some specific values using PIvot table. ?

S

sorabh

Guyz
i have a table..... which looks like this...

=================================
TT | Resp1 | Resp2 | Resp 3 | Month
=================================
1_|___0__|__2___|___1___|___1_________
2_|___2__|__3___|___2___|___1_________
3_|___1__|__2___|___0___|___1_________

..
and so on...
how can i have the pivot table calculate the following for me
.. i can put the Month column in "Page"..
but how do i do this....... Like How many responses under
"Resp1" had 0 as their value.. and how many responses
under "Resp2" had 1 as their value.. and all the possible
combinations for a given month....
please help
very urgen
 
M

M

You want use a count formula....something like this: =COUNTIF(A1:E9,"=1").
This tells Excel to count up the number of 1s in the range A1:E9. Does this
help?

M
 
P

Peo Sjoblom

There is no need really for the equal sign in this case

=COUNTIF(A1:E9,1)

will do

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top