Forum Discussion
How to link a countifs formula to a cell that changes according to another formula
Hi there, I'm trying to create a dashboard template for a work project, but am having trouble linking a formula properly. I want this dashboard to take data from another sheet, which involves ca...
I believe your problem is NOT that your are reference that other cell but rather that your 2 ranges don't have the same number of elements. One starts on row 1 and the other starts on row 3.