Thursday, September 6, 2012

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

use locomambo said: (!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
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