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 MI     www.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:

=dcount(Historial!$C$3:$T46;"PG";Q2:T3)

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

Any idea?

Thank you in advance ;^)
-------------------------------------------------------------------------------------------------------
following is a solution to the problem