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.
Thursday, February 7, 2013
yogi_Compute Stats For Condition Of Entities As Specified
post by user: Dan99999 said:(http://productforums.google.com/forum/?zx=jkl1wboolo4r#!category-topic/docs/spreadsheets/68P3ljs3Ugs) Statistics on COUNT given two columns of data (image of problem provided)
Can someone help me develop the formula for solving statistics problem. I tried using Google spreadsheet pivoting function, but without success.
I attached image of problem and solution. When providing the answer formula please note that data is in SHEET1 and stats should be on SHEET2.
Please include in formula correct syntax for referring to SHEET1rows. It's something like SHEET1!A, or SHEET1A or similar...