SUMIF formula that calculates the criteria between a number range

Having a blank mental moment. I am trying to create a sum if formula to total all of the "medium" priorities using a range of numbers. High is fine as i just did a greater or equal to (>=) and likewise (<=) for the low. When I get to the medium priority, I can't work out how to do an "in between".

Below is a screen shot of what I am working on and where the formula is up to.

=SUMIF(Score:Score, >=27, [Requested Amount]:[Requested Amount])

What do I put after the 27? Number range finishes at 53.

Many thanks!!

Tash

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!