#### AK_Excel_13

##### New Member

- Joined
- Jul 11, 2014

- Messages
- 30

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!