This is a spreadsheet example, where the first one shows the formulas, while the second one shows the calculation result of formulas.
Regarding the calculation result of cell A12, why is it 3 instead of 1, since the criteria shown in cell A3 is a simple string
A instead of
A*? Documentations about DCOUNT function cannot explain this explicitly, so I can only ask for help here. Thanks!
P.S. My Excel version: Microsoft Excel for Mac 16.35 (20030802）