Monday, January 7, 2013

yogi_Compute Number Of Tickets ... Total Closed And Still_Open Row By Row For Each Person

                                          Google Spreadsheet   Post  #960
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Jan 07, 2013
user Naturalliferyan said:(!mydiscussions/docs/SjWortuP0bw)
counting percentage occurance
I have a sheet where column B2:B equals a name and column H2:H contains a percentage.
I am trying to count the total number of accurances that column B2:B=Ryanand h2:H=100%. When I try and use the
following formula i get a parse error. Any help would be so appreciated.

=arrayformula(sum('Main Ticket System Data'!B2:B=ʺRyanʺ)*('Main Ticket System Data'!H2:H="100%"))

OK here is a copy of the workbook I am trying to get working. I Hope this helps. I am simply try to sum the occurnces
of 100%(s) where the name Ryan as a criteria is meet.

Ryan :)
following is a solution to the problem