ExcelBanter - DCOUNTA function not working right

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - DCOUNTA function not working right (https://www.excelbanter.com/excel-programming/389894-re-dcounta-function-not-working-right.html)

merjet

DCOUNTA function not working right

I can't explain it, but here is a work-around:
=COUNTIF(B4:B15,B3)
To use more criteria, add COUNTIF's.

Hth,
Merjet

All times are GMT +1. The time now is 09:48 AM.