Sum with NA

[slinkyjib]

Good Morning,

I'm trying to get a forumla to sum a column. But the contents of the column are variable, and may contain N/A. As such I need to sum all the amounts in the column that contain a value, whilst excluding N/a.

My attempt looked like this, though I really am not that good with isna formula's. ( Hope it doesn't show to badly).

=IF((ISNA('Cost & Customer Number'!H4:H2000)),"",(SUM('Cost & Customer Number'!H4:H2000)))

Any help appreciatted.

 

[Peter_SSs]

slinkyjib

Try
=SUMIF('Cost & Customer Number'!H4:H2000,"<>#N/A",'Cost & Customer Number'!H4:H2000)