Hi all
I'm working with the following formula:
=IF(AND(SUM(COUNTIFS(INDIRECT({"Q3","R3","S3","T3","U3"}),"Yes",INDIRECT({"Q5","R5","S5","T5","U5"}),P5))>=1,P3="Yes"),"Free","Not Free")
However if I try to copy this down the cell references do not automatically change for each row (i.e. I'd like "Q3" to become "Q4", "Q5", "Q6" etc. as copied down).
Does anyone know if it's possible to make this formula dynamic?
Many thanks