Countifs(range1;not empty...)
Morgan13300
Posted messages
2
Status
Membre
-
Morgan13300 Posted messages 2 Status Membre -
Morgan13300 Posted messages 2 Status Membre -
Hello,
I'm looking to complete the formula below:
=COUNTIFS('Sheet1'!A1:A1000;not empty;'Sheet1'!B1:B1000;not empty)
Of course, I've tried:
NOT(ISBLANK())
<>""
but I can't get it to work
Help me
I'm looking to complete the formula below:
=COUNTIFS('Sheet1'!A1:A1000;not empty;'Sheet1'!B1:B1000;not empty)
Of course, I've tried:
NOT(ISBLANK())
<>""
but I can't get it to work
Help me
1 réponse
Hello,
Here is your corrected formula :)
=COUNTIFS('Sheet1'!A1:A1000,"<>",'Sheet1'!B1:B1000,"<>")
However, rather than doing A1:A1000, it is preferable to select the entire column directly; it's generally simpler
=COUNTIFS('Sheet1'!A:A,"<>",'Sheet1'!B:B,"<>")
Let me know if this works for you
Best regards
A conquer without peril is to triumph without glory.
Pierre Corneille, Le Cid
Here is your corrected formula :)
=COUNTIFS('Sheet1'!A1:A1000,"<>",'Sheet1'!B1:B1000,"<>")
However, rather than doing A1:A1000, it is preferable to select the entire column directly; it's generally simpler
=COUNTIFS('Sheet1'!A:A,"<>",'Sheet1'!B:B,"<>")
Let me know if this works for you
Best regards
A conquer without peril is to triumph without glory.
Pierre Corneille, Le Cid
Thank you very much