works great thanks
--
Gary


"John C" wrote:

H5: =(H7=16)*SUM(C43:M43)
--
** John C **

"Gary" wrote:

I am trying to create a formula that checks the value of h7 if it is <16
then h5 = 0 else h5 =sum(c43:m43)
can anyone help? thanks
--
Gary