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.
Wednesday, February 20, 2013
yogi_Perform Multi-Conditional Count In Another Sheet
Google Spreadsheet Post #1039
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Feb 20, 2013 user Monica Rampani said:(http://productforums.google.com/forum/?zx=icnslbsw6sms#!category-topic/docs/spreadsheets/KTDN9AnBfKo) Array Formula based on Date Range and Multiple Criteria Any help would be much appreciated. I have the following spreadsheet:
A B C D E
Timestamp UsernameFA Code Date Installed
This information is on the first sheet called "Job Log Submissions". On another tab I have a sheet called "Stats". What I want to do is have a formula that will tell me how many entries each Username Installed within a date range from column A.
For example, I want to know how many sites did James install (a "yes" answer) between 1/30/2013 and 2/2/2013 based on column A (not column D.) The answer with the above example should be 1.
I have been playing around with Array Formulas but can't seem to get it right. This is what I tried: