Formula will not update when you data is entred

Originally Posted by garypacha

however, when i use the following formula it works, but once dropping in new data the formula gives me #value back

What formula?

Can you attach a sample workbook?