Sumif

[Hapitaron10]

I have a list of numbers I want to pick all those that are less then 1
and add them together , I don't know what cartirea to use? i.e. sumif
(h15:h35,????,h15:h35)
thanks

 

[Ron Coderre]

Hapitaron10

For values in A1:A10

This formula adds the values that are less than 1:

B1: =SUMIF(A1:A10,"<1",A1:A10)

Does that help?

Regards,
Roin

 

[Guest]

=sumif(h15:h35,"<1",h1:h35)

 

[Guest]

Hi,

try =sumif(h15:h35,"<1",h15:h35)

Is it help?
Regards from Brazil
Marcelo


"Hapitaron10" escreveu:

 

[Hapitaron10]

thank you vary much this works just fine , One more quick oni if I need
a range should I replace if i.e. isumif( a1:a10, ">=1 and <3, a1:a10)
Thanks

 

[Ron Coderre]

Hapitaron10

For a range of values, you'd need a different function

For values in A1:A10

This formula sums the values greater than or equal to 1 AND less than
3:
B1: =SUMPRODUCT((A1:A10>=1)*(A1:A10<3)*A1:A10)

Does that help?

Regards,
Ron

 

[Hapitaron10]

Works, Thank you very much