| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula or code?
is there a way to check all cells in a column that have an entry 0 then
subtract 10 from each cell 10 for the total. Some cells will have a entry of 0 column goes from k4:k99 k100 is total for column. New total is necessary to tell difference from income and entry fees for parade. Thanks in advance Ya All are a big help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula or code?
=SUM(K4:K99)-(COUNTIF(K4:K99,"10")*10)
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Curt" wrote in message is there a way to check all cells in a column that have an entry 0 then subtract 10 from each cell 10 for the total. Some cells will have a entry of 0 column goes from k4:k99 k100 is total for column. New total is necessary to tell difference from income and entry fees for parade. Thanks in advance Ya All are a big help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula or code?
Thank you Jim
"Jim Cone" wrote: =SUM(K4:K99)-(COUNTIF(K4:K99,"10")*10) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Curt" wrote in message is there a way to check all cells in a column that have an entry 0 then subtract 10 from each cell 10 for the total. Some cells will have a entry of 0 column goes from k4:k99 k100 is total for column. New total is necessary to tell difference from income and entry fees for parade. Thanks in advance Ya All are a big help |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula or code?
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 "Jim Cone" wrote: =SUM(K4:K99)-(COUNTIF(K4:K99,"10")*10) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Curt" wrote in message is there a way to check all cells in a column that have an entry 0 then subtract 10 from each cell 10 for the total. Some cells will have a entry of 0 column goes from k4:k99 k100 is total for column. New total is necessary to tell difference from income and entry fees for parade. Thanks in advance Ya All are a big help |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula or code?
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula or code?
skip my last post my lack of knowledge and to quick to respond. Need = to
and all worked ok Thanks again Curt "Jim Cone" wrote: =SUM(K4:K99)-(COUNTIF(K4:K99,"10")*10) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Curt" wrote in message is there a way to check all cells in a column that have an entry 0 then subtract 10 from each cell 10 for the total. Some cells will have a entry of 0 column goes from k4:k99 k100 is total for column. New total is necessary to tell difference from income and entry fees for parade. Thanks in advance Ya All are a big help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula or vba code | Excel Worksheet Functions | |||
| formula through vb code | Excel Programming | |||
| Add formula in the code | Excel Programming | |||
| formula or code | Excel Worksheet Functions | |||
| Help with my code and formula | Excel Programming | |||
Linear Mode
