semperduro
New Member
- Joined
- Jul 19, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I have several columns I want to sum involving a specific text string.
In E11 I want to sum "1-RAD" (the number only) when entered into H15:H62.
So if "1-RAD" is entered into H15:H62 once and "3-RAD" is entered into H15:H65 a few rows later, I want E11 to sum "4".
The VBA for it is: varTotRadar = varTotRadar + NumericOnly(varRptToSplit(0))
However, I want a formula. Having issues with VBA populating after password protecting sheet.
I may not be asking my question correctly since I haven't found anything on it. I stumbled across something the other day, but was not able to save it and have forgotten where I found what I think I'm looking for.
Thanks in advance.
In E11 I want to sum "1-RAD" (the number only) when entered into H15:H62.
So if "1-RAD" is entered into H15:H62 once and "3-RAD" is entered into H15:H65 a few rows later, I want E11 to sum "4".
The VBA for it is: varTotRadar = varTotRadar + NumericOnly(varRptToSplit(0))
However, I want a formula. Having issues with VBA populating after password protecting sheet.
I may not be asking my question correctly since I haven't found anything on it. I stumbled across something the other day, but was not able to save it and have forgotten where I found what I think I'm looking for.
Thanks in advance.