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.
Tuesday, June 18, 2013
yogi_Count Instances Of Numbers In Column B By Week For Dates in Column A
I was wondering if maybe you might have a better idea of a work around as what I came up with seems to me like it should not work.
I have an array of data where column A contains a time stamp (unique times, no repeats), and column B contains either nothing (a formula that yields a blank) or any integer from 0 to 5.
What I want is a way to see how many occurrences (time stamps) I have all total and how many occurrences of each number (don't need to count blanks, just how many zeros or ones or twos, so on) all within a time frame.
which works, however, if there were NO time stamps for a given time frame (D5 to D6) then instead of returning 0 or nothing, it returned a 1 for the date, and reported 1 zero. Which doesn't work as we have dead weeks where there are no time stamps recorded but we need to see the over all patterns from week to week over a month or so.
it contains time stamps in A2:A with their respective scores in B2:B. A representation of each formula style is there as well as a manually counted and a version pulling from a second tab (which is how it will have to work in the actual doc).