Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Formula in Code
Cells(i, "o").Value = application.sum(range(Cells(i, "I"), Cells(i, "N")))
"Juan" wrote: Hi, have following Code that I would like to modify. So instead of dividing, I want to Sum but can't seem to get the right logic. ' Dim i as long For i = 1 To ActiveSheet.UsedRange.Rows.Count If Cells(i, "A") = "" Then Cells(i, "o").Value = Cells(i, "I") / Cells(i, "N") End If Next Basically, I want to sum of columns I throuh N where Column A is Blank in Column O. Please advise any info would really appreciate it. Thanks, Juan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to code the formula? | Excel Discussion (Misc queries) | |||
formula or vba code | Excel Worksheet Functions | |||
formula to code help | Excel Programming | |||
Formula or code | Excel Programming | |||
Formula or code | Excel Programming |