Correct syntax to add a workbook name that is stored in a variable into a formula

Hello.

I have the following code, which executes just fine:

Please Login or Register  to view this content.

The problem is that I need to run this again in a different column, and the data is held in another sheet that I have given the variable StepTwo to.

I'm not sure of the syntax to do this. Basically - this is what I need the code to do:

Please Login or Register  to view this content.

Understandably this is totally incorrect, but it's the best I can do to explain what I'm actually trying to do....

The two parts of SUMIF are both held in a workbook that I've given the variable "StepTwo" to.
Both sets of data are also held on Sheet(1) of that workbook.

Help?

Thanks so much. Is there a website that shows how to correctly do the syntax for this? I've posted about 3 or 4 times for different scenarios involving using variable names in formulas. e.g. - where to add the single quotes ( ' ) and the brackets ( [ ] )

I just realized this is a SUMIF, so I need 3 variables, not just 2. I've tried adding it in, but I'm getting another syntax error.

Please Login or Register  to view this content.

This should read:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I did something wrong though, and I'm getting an Application-defined or object-defined error....

I was working directly off of what Alphafrog gave me. His formula worked perfectly - the syntax, that is. I just needed to add an additional line in the middle, and I am not getting the syntax correct. (As =SUMIF has 3 properties, not just 2)

Okay! i got this to work by removing some of the crazy references I had in there. The variable I had listed as "StepTwo" will always be the same, thus, I can just use the Range() command, like so:

Please Login or Register  to view this content.

My question now - to finalize this.....

This reports a bunch of =SUMIFs back to me, which is awesome, but I'd like for it ONLY to show a value if that value is NOT zero.

Right now, I'm using this:

Please Login or Register  to view this content.

But it's 5000 lines, and it takes about 3 minutes to run, which is bad.

Is there a way I can do something I can do up front in the original formula for this? If not, I guess I could sort least to greatest, auto filter, select cells 2 to lastrow, then delete... that would be quicker than my for statement.