Variable for Criteria in SUMIF Formula

I am having trouble with a SUMIF formula. I want to select the value for my SUMIF criteria from a cell that is one row above and two columns to the right.

This works

Please Login or Register  to view this content.

This does not work

Please Login or Register  to view this content.

The result must be a formula and not a value. The numbers added may change at any time and only the numbers associated with the code one row above and two columns to the right of RngCell should be associated. That code can change.

Thank you for your help.

Works nicely, Stephen. Thank you.

Before I close this, I hope you can help me with one other item. I don't require this, but if I had wanted it, how would I add from C4 to LastRow to the SUMIF formula?

I am confused with where the quotations go. I have left the quotations that you so helpfully added in your answer. Thank you.
--Perry

Please Login or Register  to view this content.

Originally Posted by spitfireblue

You need to do it like this:

Please Login or Register  to view this content.

Note: I am not sure if you want to use SumCriteria or SumIfCriteria?
Note: I also removed the extra brackets that were not required.

It is a lot clearer now. Thank you for your time.