Count If macro

[ScabbyDog]

In the cells in range B2:GJJ32 I want to search for the word "TEST". If found, I want to look at the cell directly to the right of where it is found. This will always be a number ranging from 0 to 10. I want to find all instances of the word "TEST" and SUM all the values that are found directly to the right.

Possible?

[xladept]

Try this:

Please Login or Register  to view this content.

[AB33]

Try the attached.
Please change my columns to With ActiveSheet.Columns("B:GJJ").
It was B-J

[ScabbyDog]

Solved. Thanks!

[xladept]

You're welcome and thanks for the rep!

[ScabbyDog]

Try this:

Please Login or Register  to view this content.

If I know the word I am searching for is always going to be exactly "Test" do I need the LCase(C.Value) part or how would I alter it so that it just looks for EXACTLY "Test" and no other spellings of the word. So if it finds "test" or "TEST" it'd ignore it.

[xladept]

Like this:

Please Login or Register  to view this content.

But more exclusive would be:

Please Login or Register  to view this content.

[ScabbyDog]

It doesn't seem to work for the attached sample though. Any ideas?

[xladept]

It looks to be the wrong data - there is no field with "Test"

[ScabbyDog]

I edited the macro so it looks for a different word which is contained numerous times in the data. The macro is contained within the attachment.

[xladept]

I just realized - try:

Please Login or Register  to view this content.

[ScabbyDog]

I just realized - try:

Please Login or Register  to view this content.

Hero!

All sorted! Thanks mate!

[xladept]

You're welcome and thanks for the rep!

N.B. Since we're testing the offset for error, we can't go to the ultimate column only the penultimate