I have both vertical and horizontal data on a worksheet that is evaluating for two variables from another worksheet to SUMIF. My formula is calculating correctly when I drag down OR if I drag across (as I am freezing rows/columns with $ to indicate the constants). The problem is that it has 100+ rows and 100+ columns and I cannot figure out how to drag the formula across without entering the formula in each of the rows or each of the columns. Is there a faster way to drag a SUMIFS formula??
Help is much appreciated!!
Bookmarks