Hello
I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down.
My formula is fairly simple =COUNTIF({KPI DATA File Range 1}, "Pass") and the "Pass" changes for the other 3 columns. I just cannot seem to remember how to add the row reference.
Can anyone help?