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    Dec 14, 2012
user Unai Ardanza said:(!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

Any idea?

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