running count in horizontal row?

[bwilkinson]

Is there any way to create a running count in one horizontal thread? I can create a running count in vertical columns,but not horizontal threads?

I have a spreadsheet that I want to keep track of how many rounds mulitple weapons have fired. I have a current rounds cell, a last fired cell and total rounds cell. The problem is that when I enter the number of rounds shot in the "last fired cell", the sum of the total rounds cell goes up (via the sum function) however, is there a way to keep that number there, even though I will replace the last fired cell with a new number the next time I fire the weapon?

[JBeaucaire]

The only way to do this is I know is with VBA. That would require you using a macro-enabled workbook. Is that OK?

If so, let's clarify...every time you enter a value in column C, you want the value you enter to be added instantly to the value on the same row in column D? Deleting values from column C would have no effect on column D.

[JBeaucaire]

If yes, you're able to use macros, then use this.

1) Right-click on the sheet-tab name and select VIEW CODE
2) Paste this sheet-event macro into the window that appears:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range

For Each cell In Target
    If Not Intersect(cell, Range("C:C")) Is Nothing Then _
        If IsNumeric(cell) Then _
            cell.Offset(0, 1).Value = cell.Offset(0, 1).Value + cell
Next cell

End Sub

3) Close the editor
4) Save your sheet as a macro-enabled workbook (*.xlsm)

Now make an entry in column C and the column D value will increment. There will be no formulas in column D when the macro has run once on every row.

[bwilkinson]

that worked perfect!!!! Thank you, I could have never done that myself. I am completely igonrant when it comes to Macro..... Is there anywhere I can learn to figure this stuff out myself or basically do I have to learn to write programs?

[JBeaucaire]

I learned to write macros on forums like this solving problems one at a time, then later trying to answer other people's questions. Glad it works for you!

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)