title: Find address (cell/row) for COUNTIFS function
body: <p>I have an Excel file populated with a large amount of COUNTIFS functions (above 300). The formulas work fine but I need to be able to find the address for each COUNTIFS result as the data source is very large.</p>
  
  <p>i.e. if COUNTIFs gives me result of 1 for the selected parameters, I need to be able to know which cell/row the function is counting from the data source.</p>
  
  <p>I was thinking this could be done with the ADDRESS function, but I am not sure how this can be used together with COUNTIFS.</p>