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     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