If in cell K51 you want the sum of K3 to K50, the formula in K51 is
=SUM(K3:K50)
If K3 to K50 is where you have your values that you want to test against
150, try =5*COUNTIF(K3:K50,"="&150)
--
David Biddulph

"Peekaboo012885" wrote in message
...
thanks for the replies but I just realized I didn't word my question
correctly...I'm looking to assign that formula but to a range of cells in
a
column (k3 through k50), however I want the total of all in cell k51.

"Gaurav" wrote:

=IF(X=150,5,0)

It's better to use cell references. for example =IF(A1=150,5,0)

Thanks

"Peekaboo012885" wrote in
message
...
I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value
is
5,
if less than 150 then value is 0."