Summing up a column excluding a number

[Pauljj]

I am sure this needs to be an array function but am struggling with how it should be created.

I want to sum a range E10 to U10 I want to add up all figures excluding any occurences of the figure 20. ie

10
20
35
15
20
12

Should then equal 72

Would someone be able to help me please ?

 

[Boller]

=SUMIF(E10:U10,"<>20")

(Note : Your post heading reads "Summing up a column ...", but your sample data in your post is in one row.)

 

[Dodgy]

=SUM(E10:U10)-SUMIF(E10:U10,20)

 

[Pauljj]

Thank you for your help