SUMPRODUCT formula to ignor #NA

[Macfool]

I Have the following SUMPRODUCT formula that I am using to count the number of people between the ages of 18 & 30, it works fine except if the data is missing and it shows a #N/A the it does not calculate. I have tried various modifications to the formula such as ISNUMBER ISERROR but to no avail, hoping someone can steer me in the right direction with this.

Current formula

Please Login or Register  to view this content.

Have tried

Please Login or Register  to view this content.

Also tried

Please Login or Register  to view this content.

Thanks for any assistance

[Phuocam]

Try this ...

=SUM(IF(ISNUMBER(A3:A20),(A3:A20>=18)*(A3:A20<=30)))

Enter with Ctrl+Shift+Enter.

[sandy666]

you can try (Ex2007 and above) IFERROR(your formula,"") or for 2003 and above IF(ISERROR(your formula),"",your formula)

[Macfool]

Thanks Phuocam & Sandy, Phuocam your formula works as I need, I also found that a Countifs formula works as well

Please Login or Register  to view this content.

so I will mark this as solved, thanks again for the help.