Forum Discussion
Regarding multiple instances of countifs in a formula
Hello 🙂 I'm trying to create a formula, where I have to put multiple instances of countifs in. It currently looks like this: =TÆL.HVISER('Raw data'!D2:D1001;"League";'Raw data'!G2:G1001;...
NovaNiller You can do this with SUM and COUNTIFS using a static array { } to input multiple OR criteria into a single argument. Please see the attached example file, which should automatically adjust to work with the regional and language settings on your system...