Excel - counting cells?
916722
If you have hidden the row by setting the height to zero, which is also what excel does when you pick "format", "row","hide", then you will first have to have a way to determine the row height of each row in the range. There is not a function to do this in excel (although there is one to determine width), but here is a link to a page that can tell you how to create one\n\nhttp://groups.google.com/group/microsoft.public.excel.worksheet.functions/browse_thread/thread/65d8576809d44e8d/a502f72888df4806%23a502f72888df4806\n\nAfter you've done that, you could probably use a =DCOUNTA(range,column offset,criteria) function.  \nFor your criteria value you would have to use something like =AND(RowHeight()>0,ISNUMBER())\n\nYou would have to play around with the syntax and exact functions depending on whether you are counting numbers or text, and remember you need to build the rowheight function before putting it in the formula.\nI find it is best to build a complex formula from the inside out. For instance, start with just the isnumber formula and make sure it returns a valid result. then try the rowheight formula you've built and make sure it returns a valid row height on just a current cell, before you us it as a criteria. then put them together within the logical =AND function.\nyou might want to play with working with common functions within an =and before trying the =rowheight function.
182120
What is this pertaining to? Excel? You should refine your question.
738595
Try this:\nRange("a1").Select\nc_value = Trim(ActiveCell.Value)\nmsgbox ("You have " & c_value & " cookies")
505781
Sub ChooseLastRow()\n\nRange("A1").Activate\nDo until activecell.value = ""\nActivecell.offset(1, 0).activate\nLoop\nactivecell.offset(-1, 0).EntireRow.select\n\nEnd Sub\n\n\nDo what ivpjennings suggested. MUCH more elegant. Completely forgot about that!\n\nBe careful with the xlLastCell. There's a bug in Excel. If you are working with your data and you delete a few rows, the xlLastCell will still be the last row of the original data set, not the updated last row after the deletions. Only after saving the file, will xlLastCell return the true correct last row.
202107
Try this:\n=IF(A1>0,A1-(A1*0.1),A1) \nin cell C1. \n\nAlso, you didn't specify what happens when A1=0. If C1 = A1, then the above will work, if not, try this:\n=IF(A1>0,A1-(A1*0.1),IF(A1<0,A1,Zero Value))
747458
Rowcount instead of count.
444067
Put this in C1:\n\n=(12-A1)-(12-B1)\n\nHave the cell formated to time.
1070066
R[1]C[1] - style references make my head hurt, but I will point out that there are plenty of ways you can use a variable to manipulate formulas. Here's one that would put formulas in 100 rows in column 1, referencing cells on row 1, columns 2 thru 101 (apologies in advance if the wordwrap goes wonky):\n\n    Dim plCounter As Long\n    For plCounter = 1 To 100\n        Worksheets("Sheet1").Cells( plCounter , 1).Formula = "=Sheet1!R[" & (-plCounter + 1) & "]C[" & plCounter & "]"\n    Next
995507
A cell can either contain data or a formula, not both.\n\nYou will need to create a macro and assign it to the onChange event for that cell.
1120124
Not sure if this is what you mean, but ...\nCreate an Excel sheet,\n\nRow 1 is the titles, in this order\nDate, Value, Sale, Month 1, Month 2, ... Month 6, Month 7, Sale Total, Accumulated Total.\nYou can use whatever titles you want.\n\nIn Row 2,\nLeave Date and Value blank.\nIn Sale, type '=B2*0.045',\nIn each month, eg, Month 1, Month 2, etc, type '=B2*0.025'\nIn Sale Total, type '=SUM(C2:J2)'\nIn Accumulated Total, type '=SUM(K2)'\nSelect the columns, C2 to K2, then grab the little square in bottom right hand corner of the selection you just made.  Hold you mouse button down, go down the page to how many entries you want.\n\nThe only thing you will have to do manually, is to update the Accumulated Total column.\nRow 3, =sum(k2:k3)\nRow 4, =sum(k2:k4),  etc
964099
Just go to the Cell that you want the total in.\n\nType +sum(d2..d6) where d2 = your first cell to be added and d6 = your last cell to be added.\n\nYou could also use the AUTOSUM button on the top toolbar.\n\nHighlight the cells you want added and hit the button.\n\nHover your cursor over the buttons till you find it.
1072460
Paste this macro into VBA\n(The >s represent tabs, please replace them. Tabs are really just for aesthetics, but help in macro troubleshooting)\n\nSub Del_Mt_Rows()\nDim lastRow As Long\nDim r As Long\n>lastRow = ActiveSheet.UsedRange.Row - 1 + _\n>>ActiveSheet.UsedRange.Rows.C...\n>Application.ScreenUpdating = False\n>For r = lastRow To 1 Step -1\n>>If Application.CountA(Rows(r)) = 0 Then Rows(r).Delete\n>Next r\nEnd Sub\n\nThen just run the macro and it will remove empty rows
955614
in excel you would use formulas such as =a1*3 in each cell to make the effect work from a starting number.  In HTML, you would actually use an XML table and/or some kind of scripting such as vbscript or javascript.
275977
For even numbers use formula\n=IF(MOD(Cell coord with original number;2)=0;Value you want to perscribe the active cell)\n\nFor odd numbers:\n=IF(MOD(Cell coord with original number;2)<>0;Value you want to perscribe the active cell)
738891
A simple way is to make the cell a colour until it is filled with an amount.  You can do this through conditional formating under  Format.  For example if you say Cell value is equal to 0 then  format the cell Red.  If you put in a value other than 0 the red will disappear.
523638
Put 5 in cell A1\nPut 2 in cell B1\nTo subtract, in cell C1 put  =A1-B1\nAfter enter key, the answer 3 appears in cell C1\n\nYou can test it by changing the numbers in A1 and B1, it will work every time.
275388
It's been  a long time since I used excel but if I remember you just click "insert" then choose "formula" then find   "average" and choose the times you wanted to average by selecting the cells with the times you want to average. \nMake sure all your data is in the same time format and that  you have the right cells selected.\nEdit.\nIf you do not get a satisfactory answer here post this question in the sofware section. Many experts there.