I actually cannot figure out where is the ambiguity. The database to work on has to be provided in an attached worksheet as I did with "Prova1.ods". The following step is to create the DB.MEDIA function is a separate file as I did with "Prova2.ods". The DB.MEDIA (DAVERAGE) function is:
I actually cannot figure out where is the ambiguity. The database to work on has to be provided in an attached worksheet as I did with "Prova1.ods". The following step is to create the DB.MEDIA function is a separate file as I did with "Prova2.ods". The DB.MEDIA (DAVERAGE) function is:
=DB.MEDIA( 'PATH_TO/ prova1. ods'#$Foglio1. D1:E5;' PATH_TO/ prova1. ods'#$Foglio1. D1;'PATH_ TO/prova1. ods'#$Foglio1. G2:G3)
considering the syntax of the function DB.MEDIA (DAVERAGE):
DAVERAGE(Database; DatabaseField; SearchCriteria)
Database consists into
a b
1 1
2 1
3 1
100 0
in Prova1 sheet
DatabaseField consists into D1 in Prova1 sheet
SearchCriteria consists into
b
1
in Prova1 sheet
I am not able to be more specific.