curly brackets simple count

[rplim2016]

Hello Mr. Excel Gurus,

{=COUNTA(IF(CELL("format",B2:B18)="D4",C2:C18))}

Above is my simple formula that counts the values in column C if the values in column B is in Date Format.

Isn't working, any solutions please?

Thanks

 

[James006]

Hello,

You could test following Array Formula

=SUM(IF(ISNUMBER(C2:C18),1,0))

Hope this will help

 

[rplim2016]

Hello James, thanks for the help. Not working

 

[James006]

Hello again,

As you know for an Array Formula ...

Instead of the Enter key ... you need to use simultaneously the three keys : Control Shift Enter