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.