Forum Discussion
Regarding multiple instances of countifs in a formula
If you want to use a single COUNTIFS formula with multiple criteria, you can do it in your language.
In this formula, ANTALHVISER is the Danish equivalent of COUNTIFS. The syntax is similar to the English version. The formula counts the cells in the specified ranges where the corresponding cells meet the specified criteria.
Your original formula was correct for counting cells with the criteria "League" and "W" in the specified ranges. If you want to add the "FNM" criteria, you can use this modified formula:
=ANTALHVISER('Raw data'!D2:D1001; "League"; 'Raw data'!G2:G1001; "W") + ANTALHVISER('Raw data'!D2:D1001; "FNM"; 'Raw data'!G2:G1001; "W")
This formula counts the cells where the criteria are "League" and "W", and then adds to that count the cells where the criteria are "FNM" and "W". If this is what you need, then your original formula structure was indeed correct.The text and the steps with the help of AI.
My answers are voluntary and without guarantee!
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.