One of my users is trying to use the AutoSum feature in Excel to add two cells horizontally. We are trying to add cell C4 and D4 together with the result in cell E4. When we hit autosum, you can see the formula
Inbetween each of those phrases I have excel taking a count of how many rows down the difference between the phrases is. This is stored one row up in K, we will use K18 to hold this value. Then, in the cell this If-Then yeilds a true value, I would like the sum of the two ...