COUNTIF(K4:K99,"10") counts the number of entries with
a value greater than 10. That should equal 25 in your worksheet.
25 * 10 = 250 (the amount to subtract)

You can test it by entering... =COUNTIF(K4:K99,"10") in a separate
cell and see what you get. Also try... =COUNTIF(K4:K99,"<=10")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Curt"
wrote in message
didn'i quite make it total came out 810 from 930 should of been 680 there
were 25 entries that needed 10 subtracted from
maybe if I see difference needed then I will understand how countif works.
Am lost at the *10 at end. I tried -10 no good
Thanks