G
Guest
Guest
The range below is called database
Customer $$ Code
AA 25 NB
BB 10 NB
CC 10 NB
Value and Code is called Criteria
Value Code
25 NB =DCOUNTA(database, "Customer", Criteria)
Why did I get 3? I thought the answer is supposed to be 1? Any mistakes in my formula?? Help guys
Customer $$ Code
AA 25 NB
BB 10 NB
CC 10 NB
Value and Code is called Criteria
Value Code
25 NB =DCOUNTA(database, "Customer", Criteria)
Why did I get 3? I thought the answer is supposed to be 1? Any mistakes in my formula?? Help guys