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


2 comments:

  1. hi thanks alot for you reply...but it didnt work...see the attache sheet

    https://groups.google.com/a/googleproductforums.com/d/msg/docs/-/nJI1_NYRXQQJ

    ReplyDelete
  2. Hi Samuel Paulint:

    hi thanks alot for you reply...but it didnt work...see the attache sheet
    https://groups.google.com/a/googleproductforums.com/d/msg/docs/-/nJI1_NYRXQQJ>


    Please explain What didn't work? What is your expected answer? versus the answer my solution gave for the data I used (which was based on the data in your post)
    Please supply the requested information if you want to discuss it further.


    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete