Regarding multiple instances of countifs in a formula

NovaNiller 

Absolutely! You can add another criteria called "FNM" to your formula using the SUM function and another instance of TÆL.HVISER. Here's how:

Modified formula:

=SUM(TÆL.HVISER('Raw data'!D2:D1001;"League";'Raw data'!G2:G1001;"W"),TÆL.HVISER('Raw data'!D2:D1001;"League";'Raw data'!G2:G1001;"FNM"))

This formula works by:

1. Calling TÆL.HVISER twice: Each instance counts the occurrences where the first range ("Raw data'!D2:D1001") equals "League" while the second range ("Raw data'!G2:G1001") matches either "W" or "FNM".
2. Wrapping both calls in SUM: This adds the results of both TÆL.HVISER calls, giving you the total count for both "W" and "FNM" matches in the "League" column.

Make sure you enter this formula as an array formula by pressing Ctrl+Shift+Enter instead of just Enter. This is required for formulas containing SUM and multiple ranges.

Here are some additional notes:

• You can add even more criteria by adding more instances of TÆL.HVISER within the SUM function, each with its own specific criteria in the second range.
• If you want to count separately for "W" and "FNM", you can use nested IF statements within each TÆL.HVISER call instead of relying on SUM.

I hope this helps