I have a database table (simple data table). I need to count non numeric (text) in the table. Below, is a formula I'm working for.

```
A formula in Cell F2,
=SUM(COUNTIFS(A:A,{"AM","PM"},B:B,{"X";"Y";"Z"},C:C,"="&D1))
```

*D1=date in MM/DD/YYYY

My questions is,

1) How to write the next array formula (just in case I need to add 1 more multiple criteria) in the formula above as I mention? 1st array I use "," then 2nd array I use ";" so Excel can read my formula.. HOW?

2)I want to add IF function in the formula above, and I write it as mention below,

A formula function in Cell F2,

`=IF(SUM(COUNTIFS(A:A,{"AM","PM"},B:B,{"X";"Y";"Z"},C:C,"="&D1))) `

But, the problem is, Excel can't ready my formula..I didn't get the result I want..

Please help me.

ASAP.