Subtotal visible cells with if function

Hi guys,

Simple question otherwise I'd attach a worksheet. I need a subtotal count a function to count visible cells between cell g5:g1404 if the cells do NOT equal #N/A.

I know the simple subtotal function =subtotal(3, G5:g4104) but I need it to count the cells only if the cells do not equal #N/A.

Thanks!

P.S.: Yes, I tried googling it and was unable to figure out a good answer.

If your excel 2010 and younger then AGGREGATE

Aggregate worked perfectly. You guys RULE!!! Big thanks y'all.