-
Utility of countif
I was wondering if countif has still a utility. It appears to me that the sumproduct enables to do all that contif does, including the criteria as an array. For instance the criteria <>"" can be replaced by an array --(A1:A10<>"") in a sumproduct.
Is this function kept to keep using formulas written in formers version or has it still a true utility (a case when sumproduct might not work), or is it simply much faster?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules