Use the =sumif command.
your equation would look like this:
=sumif(B1:B19,"n",A1:A19)
This means that excel will look in column B for any values that equal N and will sum the corresponding value in column A.

Use the formula wizard to the left of the formula bar if you need more help.