SUMIF with a reference to a cell

[Guest]

I'm trying to write a sumif function where I add something if it is smaller
than or equal to a particular number. However, when I do this I need to
write the number in, instead of referencing the cell where the number is
located. Is there something extra I need to do.
This is what my formula looks like right now.

=SUMIF($T$9:$T$13,"<=13.5",$S$9:$S$13)

I want that 13.5 to be a cell, but excel is not working properly when I just
click on the cell. What can I add to the formula?

 

[Sandy Mann]

=SUMIF($T$9:$T$13,"<="&U9,$S$9:$S$13)


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

Thanks

=SUMIF($T$9:$T$13,"<="&U9,$S$9:$S$13)


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

You're welcome.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk