Google sheets formula for values that are greater than or equal to but less than

[chappers]

I need a formula for a sheet which will calculate the sum of values in another sheet between a range i specify.

For example, find the sum of 'Sheet2 column A' where values in 'Sheet2 column B' are greater than or equal to 3.0 but less than 4.

Sheet2 looks like the following

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Total[/TD]
[TD]Position[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]3.0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4.6[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]3.4[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5.9[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2.6[/TD]
[/TR]
</tbody>[/TABLE]

 

[jmacleary]

Hi there. This formula will do that: =SUMIFS(Sheet2!A:A,Sheet2!B:B,">=3",Sheet2!B:B,"<4")