Yes that was it! thanks so much!

bloop

"Roberto" wrote:

=SUMPRODUCT(--(A1:A10<5),--(B1:B10))

Roberto

"bloop" ha scritto nel messaggio
...
:I have a two colums with values, A contains numbers from 1 to 10, B contains
: numerique values. Now I would like to make the sum of the values in B
: depending on the value in A, e.g. sum of all values in B fot which the
: content in A < 5