# SUMIFS and GREATER THAN OR EQUAL TO

#### AK_Excel_13

##### New Member
Column A contains my footage and Column B contains rating value.
I want to write a sumifs function that will tell me the amount of feet that have a rating value greater than 500 but less than or equal to 600.
How do I do write the formula?

Here is what I have so far, but it doesn't work.
=sumifs(A2:A5000,B2:B5000,>500 or <=600)

Thanks!

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
maybe something like...

=SUMIFS(A2:A6,B2:B6,">500",B2:B6,"<=600")

That worked!
Thanks!

I just realized that should be an "and" and not an "or"

=SUMIFS(A2:A6,B2:B6,">500",B2:B6,"<=600")

instead of the 500, can a cell reference be inserted into the formula? I want to reference a cell where I'll be changing the value.

Thanks

Hi,

Yes, sample below, change the >= and/or <= as you require:

Book1
ABCDE
1100550MinMaxResult
22003005006002000
3300200
4400800
5500750
660010
7700300
8800900
9900500
101000520
Sheet29
Cell Formulas
RangeFormula
E2=SUMIFS(A1:A10,B1:B10,">="&C2,B1:B10,"<="&D2)

=SUMIFS(A2:A6,B2:B6,">500",B2:B6,"<=600")

instead of the 500, can a cell reference be inserted into the formula? I want to reference a cell where I'll be changing the value.

Thanks

If E1 houses >500 and F1 <=600, then:

=SUMIFS(\$A\$2:\$A\$6,\$B\$2:\$B\$6,E1,\$B\$2:\$B\$6,F1)

If E1 houses jus 500 and F1 600, then:

=SUMIFS(\$A\$2:\$A\$6,\$B\$2:\$B\$6,">"&E1,\$B\$2:\$B\$6,"<="&F1)

Last edited:

Replies
3
Views
160
Replies
8
Views
332
Replies
6
Views
459
Replies
11
Views
1K
Replies
5
Views
2K

1,221,405
Messages
6,159,685
Members
451,585
Latest member
comanvitalie

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back