=SUM(IF(ISERROR(A2:C2),0,A2:C2)*IF(ISERROR(A3:C3), 0,A3:C3))/A1

Entered with Ctrl+shift+Enter rather than just Enter since this is an array
formula.

an alternate approach is to insure the cells do not display #N/A:
if you are using lookup formulas in your cell, you could handle the error
there

Example in A2
=if(iserror(formula),0,formula)

Repeat for the other five cells.

--
Regards,
Tom Ogilvy



"Jason Lepack" wrote in message
oups.com...
On Feb 13, 10:00 pm, wrote:
Hi I have the following formula

=((A2*A3)+(B2*B3)+(C2*C3))/A1

how can I get the result ignoring #N/A for example if A2 = #N/A

Please help

Thanks
Archana

if(isna(formula), "", formula)

Cheers,
Jason Lepack