How to calculate some specific values using PIvot table. ?

  • Thread starter Thread starter sorabh
  • Start date Start date
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
 
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Calculation 4
Pivot Table Calculations 3
Pivot Table Calculation 1
Pivot Table ... Suppress "0" Values? 2
Surpressing rows and columns with zero values in a pivot table 1
how do I remove #DIV/0! in a pivot table calculation field ? 2
Pivot Tables, Grouping, and Calculations 1
Pivot table calculate field 3

Back
Top