SUMIF Formula - Problem with #N/A

[magneyhead]

I was wondering if someone could with my my sumif formula please?

SUMIF(Sheet1!A3:A196,"MH",Sheet1!B3:B196)

The problem is that some of the cells contains # n/a.

How can i get the formula to ignore the #n/a?

Thanks

Charmagne

 

[Andrew Poulsom]

Try:

=SUM(IF(Sheet1!A3:A196="MH",IF(ISNUMBER(Sheet1!B3:B196),Sheet1!B3:B196,0)))

confirmed with Ctrl+Shift+Enter.

 

[magneyhead]

Thank you again