Adding 2 out of 3 Cells????

[sjr555]

Hi,

I'm wondering if any one can help me. I am after a formula to add the two lowest numbers out of three numbers. Hope that makes sense
Thanks

Simon

[Dav]

if the numbers are in a1, a2, and a3 perhaps small(a1:a3,1)+small(a1:a3,2)

does that help?

Regards

Dav

[sjr555]

Thats great thanks

[DonkeyOte]

any one of

=SUM(A1:A3)-MAX(A1:A3)


=SUM(SMALL(A1:A3,{1,2}))