Excel tip - sum columns containing n/a

If you want to add columns containting "n/a" error use this formula:

=SUMIF(Z2:Z204;"<>#N/A")