I have done a lot of reading on the SUMPRODUCT as a Countif formula.

However, my ranges are not both columns; so I do not know if they will be multiplicatively conformable.

Here is the task:

I have the following:

WorkSheet named "X"

WorkSheet named "Y"

WorkSheet named "Z"

If thei-th Row inColumn Bin WorkSheet "X" is a "T" then I would like to Count all of the cells in thei-th row of "Y" that are <= some cell in "Z". Let's call it 'Z'!A1 for now.

After typing this out, I get the feeling that it might be easier than I am making it.