SUMIF with a reference to a cell

C

conny

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?
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
S

Sandy Mann

You're welcome.

--
Regards,

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top