Kilchomanfan
Gebruiker
- Lid geworden
- 20 dec 2017
- Berichten
- 22
Hallo,
Hoe kan ik wildcards gebruiken in de formule:
[SQL]=SOMPRODUCT((INDIRECT("'"&$C$2&"'!$B$5:$B$36")=$B3)*(INDIRECT("'"&$C$2&"'!$C$5:$G$36")=$A$1)) +SOMPRODUCT((INDIRECT("'"&$C$2&"'!$B$5:$B$36")=$B3)*(INDIRECT("'"&$C$2&"'!$C$5:$G$36")="/"&A1))/2 +SOMPRODUCT((INDIRECT("'"&$C$2&"'!$B$5:$B$36")=$B3)*(INDIRECT("'"&$C$2&"'!$C$5:$G$36")=A1&"/"))/2
[/SQL]
In cel A1 staat de tekst "EVVJ" die perfect opgeteld wordt, maar hoe kan ik bv. "iets/EVVJ" laten optellen?
Alvast bedankt,
Marc
Hoe kan ik wildcards gebruiken in de formule:
[SQL]=SOMPRODUCT((INDIRECT("'"&$C$2&"'!$B$5:$B$36")=$B3)*(INDIRECT("'"&$C$2&"'!$C$5:$G$36")=$A$1)) +SOMPRODUCT((INDIRECT("'"&$C$2&"'!$B$5:$B$36")=$B3)*(INDIRECT("'"&$C$2&"'!$C$5:$G$36")="/"&A1))/2 +SOMPRODUCT((INDIRECT("'"&$C$2&"'!$B$5:$B$36")=$B3)*(INDIRECT("'"&$C$2&"'!$C$5:$G$36")=A1&"/"))/2
[/SQL]
In cel A1 staat de tekst "EVVJ" die perfect opgeteld wordt, maar hoe kan ik bv. "iets/EVVJ" laten optellen?
Alvast bedankt,
Marc