Forum Discussion
Solved
Dragging Indirect Formula Down
Hello, I am looking to copy/drag down the following formula (which is housed in C77): =COUNTIF(E77:(INDIRECT($C$75&77)),1)/COUNT(E77:(INDIRECT($C$75&77)))
Example for each row:
=COUNTIF(E77:(I...
rkrastel Try it like this:
=COUNTIF(E77:INDIRECT($C$75&ROW(A77)),1)/COUNT(E77:INDIRECT($C$75&ROW(A77)))This one can be dragged down to reference row 78, 79 etc.
rkrastel Try it like this:
=COUNTIF(E77:INDIRECT($C$75&ROW(A77)),1)/COUNT(E77:INDIRECT($C$75&ROW(A77)))
This one can be dragged down to reference row 78, 79 etc.
Riny_van_Eekelen cheers! This worked perfectly, thank you!
