I want to do countifs formula and for range of counting I would like to define with formula. e.g. instead of C1:C24 I would like to make formula that would return 24 (or different number depending on position). I tried it with match formula, but it doesnt want to work the way I entered it. Any idea what is wrong?
COUNTIFS('GENO-MED (genofit)'!$C$1:$C(match("meja";'Genome Solutions Sdn Bhd'!C:C;0));">1";'GENO-MED (genofit)'!$D$1:$D$(match("meja";'Genome Solutions Sdn Bhd'!D:D;0));"<>")