According to COUNTIF the documentation,

criterion can contain wildcards including ? to match any single character or * to match zero or more contiguous characters.

But this is incorrect because * doesn't match an empty cell.

How can I match any value, including blank?

  • In the title you was mentioned SUMIFS but the link points to COUNTIF. What formula are you trying? Besides the formula please add some sample input data and the expected result. – Rubén Jul 9 at 22:32

Using a * doesn't work because an empty cell does not have zero characters; it's basically 'undefined'. It does not match any COUNTIF criterion you can think of. This is how it's intended to be used: Test* matches both 'Test' and 'Test2':

enter image description here

To count empty cells, you'll need COUNTBLANK:

enter image description here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.