I am trying to write a formula and struggling to get it to work. The goal is
to grab a specific value (ex. €œ2€�) from two specific columns on a separate
tab. If a row has that value in either cell then I want to read a formula
from a different cell on that row. This would be repeated for each row that
has a €œ2: in that specific column. I then want the various formulas
totaled.

So, for example I create a formula in cell C7 on tab Test 1, that looks at
Column AD and AZ on tab Test 2. If cell AD7=2 and/or AZ=2, then we look at
cell BK7 which is using the following formula
=IF(BH7=0,0,(COUNTIF(BG7,"P"))). I want to do this as a range so that if
AD10, AD12, AZ20, AZ25, etc have a value of 2 then we look at BK10, BK12,
BK20, BK25, etc. I then want to sum all of the BK cells that were just read.

I have tried various combination of Countif statements and ranges and cannot
get a good value.