With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, January 7, 2013
yogi_Compute Number Of Tickets ... Total Closed And Still_Open Row By Row For Each Person
user Naturalliferyan said:(http://productforums.google.com/forum/?zx=uvm2h07tjqsa#!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. Sincerely. Ryan
=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. Sincerely,