View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
conny conny is offline
external usenet poster
 
Posts: 13
Default SUMIF with a reference to a cell

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?