Sumif

H

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
 
R

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
 
M

Marcelo

Hi,

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

Is it help?
Regards from Brazil
Marcelo


"Hapitaron10" escreveu:
 
H

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
 
R

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
 
Top