Problem with a conditional "If" statement

[EverGreen1231]

I'm writing a code to add the number of operations that are at each alarm point. However, the counter will not increment and the problem is either so simple I can't see it or I'm chasing the rabbit down the wrong the whole. Any and all help would be much obliged.

Here's the code...

Please Login or Register  to view this content.

... I would attach a spreadsheet but it seems that the uploading tool is not wanting to cooperate with my attempts.

[stnkynts]

Lots of questions: What is AlarmPoint()? Should this be sheet specific? Should you be resetting NumOfNonLockout for each iteration of i? Do you really even need both loops? What is SubNames()? What is RowNumber_2?

would be best if you could submit the sheet

[EverGreen1231]

Lots of questions: What is AlarmPoint()? Should this be sheet specific? Should you be resetting NumOfNonLockout for each iteration of i? Do you really even need both loops? What is SubNames()? What is RowNumber_2?

would be best if you could submit the sheet

Thank you for your reply.

I'm sorry for the ambiguity. I'll see if I can get a comparable spreadsheet to upload. I've also tinkered with the script, but it still does not perform as I want. I'm over-looking something simple; that's always been the case when I've had these sort of problems.

[EverGreen1231]

No luck with file uploading. I'm not sure why, but it simply wouldn't upload. I hope this representation is sufficient to clear any confusion.

Please Login or Register  to view this content.

It continues on similarly.

My basic need is to find a cell that meets a certain string criterion ("Add Here", in this case). I then need it to find the next instance where that same string occurs and add the numbers that are within those limits: Meaning, in the above example, I want to add 89, 92, and 56 together and place that value into B1; then, add 24 and 12 and place that value in B5. I had thought to set dynamic upper and lower bounds in a for loop, but that didn't pan out.

I then tinkered a little more and came up with the below code, but this doesn't produce anything of cause either; though, to me, it looked promising. ("DunDid" is an Ad Hoc value I was going to place in cell values if the code worked. It has no weight in the code.)

Please Login or Register  to view this content.

If anyone can see what I'm not seeing or has dealt with something similar to this before, any help you could give would be greatly appreciated.

[stnkynts]

Assuming you have a header row.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[EverGreen1231]

Assuming you have a header row.

Please Login or Register  to view this content.

Thank you! This works like a charm. I have much yet to learn, and you have taught me something: Thank you for that, as well.

Does this help?

Please Login or Register  to view this content.

That is very close to one of the stages of code as it morphed from one problem to the next. Thank you for your response. Much obliged.