Thursday, June 25, 2015

yogi_Count No Of Instances By Status Based On Multiple Criteria


                                           Google Spreadsheet   Post  #1970
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jun 25, 2015
question  by Kanagalakshimi Ravinttirin:
https://productforums.google.com/forum/#!topic/docs/u5hDKalwJPI;context-place=forum/docs
Count of Status based on 2 criteria
Hi all,

Hope you can help me out.
Maybe it is super simple, but I'm unable to figure it out.

I have this table:
DateTagTicket#Status
5/25/2015JMQBR42156273Work In Progress
5/25/2015D17V0P1156273Work In Progress
6/3/20157NLQ9T1156503Resolved
6/3/2015B50Q9T1156503Resolved
6/3/2015DX78XS1156503Resolved
6/3/20153KTK6V1156523Resolved
6/3/201560LP8X1156524Work In Progress
5/29/2015B8J2B2S156551Work In Progress
5/29/20156KMTRR1156566Resolved
5/29/201568H4VS1156572New
5/31/2015GZR0QH1156573Work In Progress
6/1/2015365D7M1156750Resolved

And expecting output such as
Expected Output
Date
No of Ticket
No of Tag
Status of Ticket
NewWork In ProgressResolved
6/3/201535012
5/29/201533021
5/31/201511010
6/1/201511001


I am all with success for No of Tickets and tags. But unable to do the counts for Status. Anyone?
-------------------------------------------------------------------------------------------------------------------------