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.
Sunday, December 16, 2012
yogi_Use DCOUNT For A Named Field In Another Sheet With INDIRECT Reference To DATABASE
Google Spreadsheet Post #928
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Dec 14, 2012 user Unai Ardanza said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/cQNHnIABIdQ) dcount indirect issue I have a formula like this:
I'd like to change the column 46 to a number of column in I49
I've tried putting this formula: =dcount(INDIRECT("Historial!$C$3:$T"&Historial!I49);"PG";Q2:T3) but it doesn't work