You want all the cells where the two concatenated numbers are greater than D when summed together. Is that right?
So in your sample file, just those cells which you have denoted with the single quote on row 3, right? And that single quote is not necessary for your purposes once we figure this out correctly, right?
|