Alex159Copper ContributorOct 15, 2019Formula Format Settings Hi All, I have encountered and issue with the settings of my formulas I use for work around data manipulation. When using VLOOKUPS and COUNTIFS the table or range in which the formula looks ...Show More
TwifooSilver ContributorOct 15, 2019Alex159 When you are copying down rows, lock the row references of your range by preceding them with dollar ($) signs, like this: =COUNTIFS(Sheet3!I$2:I$133,B2,Sheet3!V$2:V$133,B2)
