yogi_Tabulate Data In SoldBy And Disposition Columns In Another Sheet By RepsID And DispositionType

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #736   Sep 06, 2012     www.energyefficientbuild.com.

use locomambo said: (https://productforums.google.com/forum/#!msg/docs/RfrTcPQ9SmA/PAEDdWr4e2QJ)
i have a problem and cant figure it out..i have a google doc with 2 sheets, in the 1st sheet called details i have a column called "sold by" with the csr ids in them and another column called "disposition" with the words "active" or "cancelled" in them..and in the 2nd sheet called "totals" i have a column with each rep id with another column with active and another with cancelled..

i just need to count how many active/cancelled sales does each rep has to show on the 2nd sheet

ex:.

sheet1 sold by      dispositions           

              110         cancelled                                             

              100         active                                          

              110         active

              100         cancelled

              102         active

  2nd sheet      reps id        active     cancelled

                         100             1           1

                         102             1           0

                         110             1           1

of course this is where the formula comes in place...i have try countif, counta ect..please help.i would really appreciated thanks

-------------------------------------------------------------------------------------------------

following is a solution to a bit more generalized problem